JSON Parse Missing Objects?

Need help APIs
1

I have an API response in JSON format that I am able to parse into Bubble without issue. The data is simple a table of data, and two other objects. The table is parsed perfectly, but last two objects do not pull through into Bubble correctly.

I’ve snipped the missing values from the raw JSON data, weekNum pulls through as ‘value’ and I don’t see a yearNum value at all.

image
image1125×64 1.79 KB

Can anyone see what might be going wrong?

{
 "name": "weekNum",
 "objectType": "field",
 "value": "19",
 "pageIndex": 0,
 "rectangle": [
  0.0,
  0.0, 
  0.0,
  0.0
  ]
 },
{
 "name": "yearNum",
 "objectType": "field",
 "value": "2024",
 "pageIndex": 0,
 "rectangle": [
  0.0,
  0.0,
  0.0,
  0.0
 ]
}
2

Have you ran this through JSON lint?

3

1000006694
10000066941080×2400 237 KB

4

1000006695
10000066951080×2400 152 KB

5

I hadn’t used this tool before, but it’s in my bookmarks now, thanks!

There were no issues with the JSON, unfortunately, the issue appears to be that Bubble doesn’t recognise the “field” type, or at least isn’t parsing it correctly for me.

The solution was to add each field as a “table” which at least gets parsed into the system.

6

There is a JSON plugin called JSON assistant that might be able to help you with this and make it easier.

Our developer @NoCodeDataArtisan is the creator and could help with set up.

2 Likes
7

Feel free to send myself or him for help :blush:

3 Likes
8

Thank you for your help!

1 Like