Application ID 41F831D7-1082-9EE4-FF6C-0E7ED3481C00
Expected Behavior
Please describe the expected behavior of the issue, starting from the first action.
call an external API through a timer (which will eventually run once a week)
save data to database from that api call
Actual Behavior
Please provide a description of what actually happens, working from the same starting point.
Be descriptive: “it doesn’t work” does not describe what the behavior actually is – instead, say “the request returns a 400 error with message XXX”. Copy and paste your logs, and include any URLs.
External API is called
I know the data is being provided by the external api but cant save the body/data elements provided by api.
That’s closer than I got! Thank you, but I actually need a column for each of the fields in the data element of the API response which is what my Bubble app does just now but I find bubble very slow so trying out Backendless after some recommendations.
I’m trying to get all 29 fields of the data response into their own columns.
To do this, extract the value of the data property from the response and pass the resulting object into the Save Object in Backendless block. Please let us know if that approach works for you.
Interesting, thanks Stanislaw. Looks like there is potentially less processing involved in your method and potentially faster/easier to execute in the server?
I don’t think there will be any noticeable difference in performance here. The code will execute very quickly, and 99.9% of the execution time will be taken by a request to a third-party API in your HTTP/s block. The only difference I wanted to show is the ability to use fewer blocks without losing readability, thus reducing the number of things that you, as a developer, need to support in the future.
Hi Mark,
Thank you for showing it but I still don’t understand how to use it, I tried like the following image but I’m not sure if i’m doing something right because I don’t know what value to input.
You can print anything that will facilitate solving the problem. I don’t quite understand what the problem is, but with the print block you can have a way for the logic you create to report it’s state (variables, service responses, etc) back to you via logging.
Okay mark, I’ll try to explain again the problem I’m having, so I’m trying to periodically fetch data from the external api and store it in a table.
I’ve tried to make codeless logic like above but no data goes to the table except the default backendless column. The External API is https://sheetdb.io/api/v1/vzbb00lwx9aot
and logs looks like this
it’s true that the data is in an array, that’s the problem, I’m confused about how to map the data to a table. I need help and advice because I really don’t know about this yet.
