Clean up JSON Display as Text

jas2jamili · 2024-07-28T22:25:57.062Z

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 · 2024-07-28T23:17:48.959Z

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 · 2024-07-28T23:51:55.325Z

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 · 2024-07-29T12:45:46.333Z

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.

system · 2024-10-06T22:26:47.116Z

This topic was automatically closed after 70 days. New replies are no longer allowed.