Clean up JSON Display as Text

[jas2jamili]

Hi I am using Google Maps API to find places by an address and the results is in JSON format. How can I display the data as text? in a repeating group.

I tried som plugin and had no luck. Please advise.

{
“places”: [
{
“formattedAddress”: “448 S Hill St, Los Angeles, CA 90013, USA”,
“displayName”: {
“text”: “Perch”,
“languageCode”: “en”
}
},
{
“formattedAddress”: “550 Flower St, Los Angeles, CA 90071, USA”,
“displayName”: {
“text”: “The Delphi Downtown LA”,
“languageCode”: “en”
}
},
{
“formattedAddress”: “317 S Broadway, Los Angeles, CA 90013, USA”,
“displayName”: {
“text”: “Eggslut”,
“languageCode”: “en”
}
}
]
}

[davidb]

In the expression where you reference the data returned from the API, look for a value like ...places item to use as the repeating group’s data source. Then, within the repeating group’s row you can reference Current cell's formattedAddress.

[jas2jamili]

thanks David. I am using Make.com because the API takes more than 30s and Bubble timeout. Then I write the result from Make in the Bubble Table.

If i parse in Make the Table doesn’t write all the result of each item.

[davidb]

@jas2jamili

the API takes more than 30s and Bubble timeout

Many other forum contributors use the Google Maps API. Maybe there’s a different way to approach your need that doesn’t result in a timeout.

@jas2jamili

If i parse in Make the Table doesn’t write all the result of each item.

I’ve used Make with a non-Bubble app platform and database, but not with Bubble. My recollection is that within Make you can parse and transform the data it receives into what you need to write it to an external location. Maybe try sharing more precise details of your Bubble workflow and the data it receives from Make.