Accessing JSON-formatted data without REST?

#1

Is there a way to get data from a specific URL responding with JSON data as accessing the URL actually runs a php-script and returns JSON data.

#2

If the endpoint returns JSON, then you should be able to use the REST data integration (via Data tab from the global toolbar at the top), regardless of how the backend itself is implemented. Did you try to do it that way yet+

There is also the advanced HTTP request flow function, but in most cases, the REST data resource integration should be enough and is the preferred one, since it has e.g. schema auto-detection etc.

1 Like
#3

Yes, I got it to work. Just needed to use “Get One”, not “Get All”.

#4

I’m trying to do something similar, and am getting an error.

Screen Shot 2020-03-22 at 12.11.56 PM
Screen Shot 2020-03-22 at 12.11.56 PM2052×892 85 KB

The url with the json file is:

https://www.trub.com/wx_icons/wxicons.json

My webserver logs show that the appgyver back end is able to serve it (200 OK), so I’m at a loss. Per jsonpath.com, it’s valid json but the test tab just says “Failed to fetch”.

One thing I noticed is that objects (resulting data structure) don’t like keys that are numbers? Is that possibly the problem?

Any other suggestions?

#5

The number keys would sound like an issue, Composer currently doesn’t like objects with number props… You can see the exact error if you open the browser web inspector and see how the request gets resolved.

An alternative way is to use just the HTTP request node, which will fetch any kind of JSON data as-is, and then save it as-is to an app variable like icons that’s just object type without specific schema. The data will be there, even though you can’t define a schema to match it. Then, you should be able to use LOOKUP(appVars.icons, "200") to get the data.

#6

Moi,

sain uusimmalla Testflightilla tällaisen virheen iPadiin kun päivitin jo viikkoja sitten alunperin aloittamaani appsiä. Appi toimi ensin mutta kun päivitin sen “SAVE” selaimessa, tuli tämä virhe.

En keksinyt miten saan tämän taas toimimaan… any ideas? Virhe toistuu vaikka käynnistäm testflightin uudestaan.

Vai onko Testflightista uusi versio tms?

Kiitos.

Antti

CONTEXT: App, TIMESTAMP: 1585667842855, MESSAGE: undefined is not an object (evaluating ‘Object.keys(t.query)’) keys@[native code]

/private/var/containers/Bundle/Application/0597111A-3E87-4938-8474-C6F962AEAA95/RNVApp.app/main.jsbundle:2366:2555

map@[native code]

b@/private/var/containers/Bundle/Application/0597111A-3E87-4938-8474-C6F962AEAA95/RNVApp.app/main.jsbundle:2366:1933

/private/var/containers/Bundle/Application/0597111A-3E87-4938-8474-C6F962AEAA95/RNVApp.app/main.jsbundle:2366:1840

n@/private/var/containers/Bundle/Application/0597111A-3E87-4938-8474-C6F962AEAA95/RNVApp.app/main.jsbundle:2364:5409