Convert Single Json Object to a List

Need help APIs
1

Hello bubblers.

I am working with crm api that allows me to call an option set field directly.

The response is a single json object called data, with a nested list of key value pairs.

It is those key value pairs I would like to use as a dynamic drop down. Unfortunately, bubble only recognizes the single object called “data”, and does not treat the list of key value pairs as a list of objects.

see image:

image
image1977×1217 197 KB

Any tips?

1 Like
2

Bubble recognizes all value pair. The issue is that the API provide a dictionnary of key pair and not a list (array).
You could probably set the API to receive a text and convert it to a list using split by or extract with regex.

1 Like
3

So fiddling with using find & replace I was able to turn the object into a list of objects. This was able to get bubble to recognize there were several items.

So from this:

{
"ResponseCode": 200,
"ResponseText": "OK",
"Data": {
    "740300008": "Accounting",
    "740300005": "Advanced Find / Reporting",
    "740300007": "Automation",
    "740300000": "Classes",
    "740300006": "Committees",
    "740300002": "Core",
    "740300003": "Dues",
    "740300001": "Meetings",
    "740300004": "Membership",
    "740300009": "Other"
}

}

To This:

{
"ResponseCode": 200,
"ResponseText": "OK",
"Data": 
	[{
    "740300008": "Accounting"
	},
	{
    "740300005": "Advanced Find / Reporting"
	},
	{
    "740300007": "Automation"
	},
	{
    "740300000": "Classes"
	},
	{
    "740300006": "Committees"
	},
	{
    "740300002": "Core"
	},
	{
    "740300003": "Dues"
	},
	{
    "740300001": "Meetings"
	},
	{
    "740300004": "Membership"
	},
	{
    "740300009": "Other"	
	}]

}

However, I believe the desired format should be this:

{
"ResponseCode": 200,
"ResponseText": "OK",
"Data": 
	[
		{
		"value":"740300008"
		"display":"Accounting"
		}'
		{
		"value":"740300005"
		"display":"Advanced Find / Reporting"
		}'
		{
		"value":"740300007"
		"display":"Automation"
		}'
		{
		"value":"740300000"
		"display":"Classes"
		}'
		{
		"value":"740300006"
		"display":"Committees"
		}'
		{
		"value":"740300002"
		"display":"Core"
		}'
		{
		"value":"740300003"
		"display":"Dues"
		}'
		{
		"value":"740300001"
		"display":"Meetings"
		}'
		{
		"value":"740300004"
		"display":"Membership"
		}'
		{
		"value":"740300009"
		"display":"Other"
		}
	]

}

Is there a plugin that helps one turn these key value pairs into attributes of an object?

If not, I am wondering if I would need to write a custom action to do this.

1 Like
4

Yes, you need some custom action for this.
If you need my help please DM me.

5

Hey Reggie, did you figure this out? I have a JSON with about 70-80 key value pairs that I need to be a list of individual objects. :grimacing:

6

Did you ever figure this out? I’m having trouble saving API data formated in JSON as a list.

1 Like
7

Hi, I’m stuck with same thing, I just set the API Call like text, but now I do not get covert every value in a option for a dropdown. Could you please helpme

8

Please share payload you need to deal with. API Doc url too if possible (and which endpoint you are calling)