How to config data JSON payload for external application

Need help APIs
1

Hi all!

I have the following simple database in Bubble:
“seriesId | text | country”

My developers created an external application and asked me if it is possible to handover the Bubble data in a precise JSON format. I already changed the structure of the actual database so it only contains relevant fields. The external application will use the GET call from the data API every X hours.

When I use the data API to receive the data I receive this:
“response”: {
“results”: [
{
“country”: “XX”,
“text”: “XX”,
“seriesId”: X,
“_id”: “1511167989416x123378709674065920”
},

Is there any way I can format this as (change the array names and hide the ïd):

“series”: {
“serie”: [
{
“country”: “XX”,
“text”: “XX”,
“seriesId”: XX
},

I couldn’t find any other format options, maybe something with API workflows?

I hope somebody can help me.

Thanks!

Silvio

2

As far as I know Bubble gives

{
    "status": "success",
    "response": {
    }
}

when you crate an API endpoint and the call is OK, don’t know if you can change it.

3

I’m using the data API:

For instance “https://xxxx.bubbleapps.io/version-test/api/1.1/obj/xxx” using a GET.

4

Data API is even more predefined…

5

Did you even read my question?

The response I pasted into this topic is a result from Postman with a GET on the data API.

6

When I use the data API to receive the data I receive this

You would like to change the format of JSON that is returned from your app in Bubble via Data API? I don’t believe this is possible, the documentation is here. That’s what I meant by “Data API is even more predefined” in comparison to workflow APIs.

I couldn’t find any other format options, maybe something with API workflows?

As I explained, from Workflow API calls (described here) you get the structure with “status” and “response” parts, and I don’t know if you can change it - I believe not.

7

Sorry, then I misunderstood you, thanks for the response.

8

No problem at all.

Since providing APIs is the server responsibility, I expect (hope :grinning:) that when server plugins will be available we will get that kind of possibilities.