Please bear with me, what I’m about to explain can appear to be confusing, nonetheless I hope someone can help me.
I’m trying to insert the response of an API request in the database but Bubble creates a new line per objects whereas I want the values to be in the same line but in different columns which should not be surprising because it’s how it should be. Here the response I get:
As you can see below, the response is composed of two types of data: Name and Value. What I would like Bubble to do is parse the Value’s value in each corresponding Name’s value. The Value’s value is actually the Name’s value value. For instance: DEFAULT_LOCALE is the Data type and fr is it’s value.
Unfortunately, even if I create different data types corresponding to the Name’s value, I didn’t manage to tell Bubble to parse the Value’s value in the corresponding Name’s value in the database.
I even edited the raw data to get the result I wished but the database was filled with blank lines. Here is how I edited the raw data :
Here is the result I get:
Not only is it blank but it also creates a new line for each value whereas I would like it to be in the same line and in each corresponding column.
Thank you guys !