API Connector - NDJSON

[EthanB]

Hello,

I have an API that returns a NDJSON response instead of JSON (examples below). Unfortunately, when using the API connector it doesn’t recognize the NDJSON response so therefore I can’t import the data into my app.

Does anyone have any ideas on how I could solve this issue? It would be greatly appreciated.

JSON example: https://gist.github.com/rfmcnally/591d24725853395c035b67168556a522#file-json-sample-json
VS
NDJSON example: https://gist.github.com/rfmcnally/0a5a16e09374da7dd478ffbe6ba52503#file-ndjson-sample-json

[EthanB]

@staff Is it also possible that the API Connector could potentially be updated to support NDJSON?

[mikenike6]

You may have to consider creating your own plugin and leveraging a server-side action with some JS there to get the data you need and return it to bubble in that way.

[manikandan]

Yes, this to be good idea.

[EthanB]

I see. I’ve just found another way to do it that doesn’t involve coding.

I am able to import the NDJSON to Parabola.io and create a workflow that organizes the data into JSON which is then exported to my bubble app.

[mikenike6]

Nice! I haven’t heard of Parabola so I will have to check it out.

[EthanB]

Yeah, I’ve been using it for the last five days and it’s an absolute game changer. All external data now goes through Parabola and it’s made my app so much better. I can make so many changes and even set timers so it runs through workflows at specified times.