I understand what you mean now and why this create issue with sorting.
Some idea I can see:
A) Create a plugins. But honestly, this is complex. Output an object for server-side/client-side
B) Create Two API Call. One will get data as text (what you actually get). Action will transform the payload to fit the one you want and output a json file (using a plugin like : Generate and Download Files Plugin | Bubble)
The second API Call will do a GET request to the created file url
C) Use another tool like Integromat. You have one API Connector that call Integromat endpoint, Integromat call the API you want, transform the JSON payload and return it at the end
2 Likes