Nested Fields API Endpoint - HELP!

[AliFarahat]

Hello All,

I am trying to integrate a bubble app with Shopify webhooks. So far I can access all the data the data that Shopify sends through the webhook and Bubble API endpoint, but I can’t seem to access nested fields!

The data I am trying to access is in Shipping_address, but the best I can do after playing around in bubble is getting a data response of [object Object]

Does anyone know what to do? Unfortanatly I can’t use any services like zapier or springblock I must achieve this in Bubble alone.

The JSON data is

"fulfillment_status": "pending",
"tax_lines": [],
"tags": "",
"contact_email": "[email protected]",
"order_status_url": null,
"shipping_address": {
    "first_name": "Steve",
    "address1": "123 Shipping Street",
    "phone": "555-555-SHIP",
    "city": "Shippington",
    "zip": "K2P0S0",
    "province": "Kentucky",
    "country": "United States",
    "last_name": "Shipper",
    "address2": null,
    "company": "Shipping Company",
    "latitude": null,
    "longitude": null,
    "name": "Steve Shipper",
    "country_code": "US",
    "province_code": "KY"
},

[adrien]

Sadly, it is my understanding that Bubble currently doesn’t work at all with nested JSON (receiving them).
I had the same issue with Quickbooks.

[mishav]

It might be worth having a second API call that is of type Text, then parse it yourself with functions like find & replace, etc. Pretty messy.

Or, send the resulting text to another web service that returns it back in a form you want. This way you can use something like zapier, etc.

[AliFarahat]

That was my initial thinking but unfortunately I can’t since I can’t save the data in the database as it shows as [Object object]. The wired thing is the API connector plugin is advanced enough to recognize the need fields but the end point API is not as developed to Handle this…

[mishav]

Good point, @AliFarahat, setting as text doesn’t work.

Do you retrieve an id for the event as part of the top-level data?

The API endpoint workflow could use this id in an API connector call back to Shopify to retrieve the details including shipping address.

[AliFarahat]

Yes that’s what I am planning on doing as a work around. Off course this means that I would need to OAuth the app now and this made it allot more Complicated…