Services Plugins FAQs

JSON Toolkit array conversion issue

Help Needed
#1

Hello. I am testing the JSON Toolkit plugin. My primary use is to convert a bubble object that is pulled via an API call to an external db. For the most part the plugin has worked well. The one issue encountered was converting an array column. The expected JSON structure is below. In this example the static_sport_id_list field is ignored and not converted. Can you please look into this issue? It would be greatly appreciated. Thank you. Naveen

{
“id”: 1,
“label”: “”,
“static_sport_id_list”: [1],
“static_governingbody_id”: 1,
“sortorder”: 1,
“isvisible”: true
}

#2

Hi @naveenreddyla ,

Thank you for reaching out!

I’ve checked the plugin on my end, and it’s working as expected, just like on the Live Demo Page. Could you please provide a bit more information about your specific case:

  • The version of the plugin you’re using
  • The browser you’re working with
  • A screenshot of your element tree and workflow setup
  • If possible, a Loom video showing the issue

This will help us troubleshoot the issue more effectively.

Looking forward to your response!

Best regards,
Mina

#3

Hi @naveenreddyla,

I just wanted to check in on my previous message. Were you able to gather the details I mentioned? These details will help us troubleshoot more effectively.

If the issue has been resolved on your end, please feel free to let us know too!

Looking forward to hearing from you!

Best regards,
Mina

#4

Hi Mina,

I apologize for the delayed response. I will send you an example of the tomorrow when I get a chance to replicate the issue.

I appreciate your patience.

Naveen

#5

Hi @naveenreddyla ,

Thank you for your reply, looking forward to the example when you get a chance to replicate the issue. I appreciate you taking the time to follow up. :pray:

Best regards,
Mina

#6

Hi Mina,

The easiest way to explain the problem is to provide the expected JSON output vs. the actual output from the plugin. In the example below the expected JSON has a key value pair “static_sport_id_list”: [6,7]. This is an array value. Below, I have the actual output from the plugin, which the bolded output represents the same JSON output. As you can see, there is no key/value pair for static_sport_id_list. The same holds true for all the output. It seems that the plugin is not processing arrays.

Let me know if you need any other information.

Thanks,

Naveen

{
“id”: 16,
“label”: “US Volleyball”,
“url_logo”: “https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USVolleyball7jSqIgNF4s”,
"static_sport_id_list": [6,7],
“isvisible”: true,
}

[{"_api_c2_id":8,"_api_c2_label":“AAU”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/AAUCNZ4iVHf8S","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":16,"_api_c2_label":“US Volleyball”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USVolleyball7jSqIgNF4s","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":5,"_api_c2_label":“AYSO”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/AYSOB4k5pgLF8m","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":15,"_api_c2_label":“Little League”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/LittleLeague9YYuLUslnP","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":7,"_api_c2_label":“NFL Flag”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/nflflagkLXfvsE5hv","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":10,"_api_c2_label":“National Youth Cricket League”,"_api_c2_url_logo":null,"_api_c2_isvisible":true,“body_raw_text”:null},{"_api_c2_id":2,"_api_c2_label":“PONY”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/PONYT8piMjwuOI","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":9,"_api_c2_label":“US Dodgeball”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USDodgeballlHCbsnO07K","_api_c2_isvisible":true,"body_raw_text”:null,

{"_api_c2_id":14,"_api_c2_label":“US Field Hockey”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USFieldHockeyE0FkOUKoAt","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":12,"_api_c2_label":“US Flag”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USFlagoMCt3FMyos","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":6,"_api_c2_label":“US Football”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USFootballMttin331nL","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":13,"_api_c2_label":“US Hockey”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USHockeyCpyTPdQbEd","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":17,"_api_c2_label":“US Lacrosse”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USLacrosseCYMIKZokM5","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":3,"_api_c2_label":“US Softball”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USSoftballxNIThwbHQe","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":11,"_api_c2_label":“US Ultimate”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USUltimateL3bz6IP6qd","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":4,"_api_c2_label":“USSSA”,"_api_c2_url_logo":“https://qsebxwtzwcaezjgbvbgs.supabase.co/storage/v1/object/public/logos/USSSA6SfaY3MYeq","_api_c2_isvisible":true,"body_raw_text”:null},

{"_api_c2_id":1,"_api_c2_label":“no value”,"_api_c2_url_logo":null,"_api_c2_isvisible":false,“body_raw_text”:null}]

#7

Hi @naveenreddyla ,

Thank you for the detailed explanation.

I was able to test it on my side, and it’s working as expected. I confirmed with the Dev team that the action “get keys from JSON” can only receive text format. So, if your parameter format is set as “array,” you will need to convert it into text first before proceeding with the “get option from API” action.

image
image770×56 1.45 KB

Could you please share the format of your parameter, along with a screenshot of your setup and the debugger? Alternatively, you can create a Loom video showing the setup. This will help us better understand how things are configured on your end.

Looking forward to your response!

Best regards,
Mina

#8

Hi @naveenreddyla ,

Just following up to see if my previous suggestion helped resolve the issue you were facing with our plugin. Could you kindly confirm whether everything is working fine now, or if you’re still encountering any problems? :pray:

Looking forward to hearing from you soon!

Best regards,
Mina

#9

Hi Mina,

The field that is having the problem is and integer array field coming from Supabase via a plugin. If I set the field (static_sport_id) as a number array data comes in as a number, but as you indicated cannot be handled by the JSON plugin and thus the field is ignored. If for example the array contains the values [1,2], the values are available within Bubble as “1,2” However, no corresponding key for static_sport_id is written

image
image975×326 23.8 KB

image

If I then set the field to a text array I get a type error in the console from the Supabase and the Get Things as JSON plugin.

image
image975×314 23.4 KB

image
image975×540 227 KB

If I set the field type to text, the static_sport_id key is written but there are no corresponding value

image
image975×318 23.5 KB

image

If I set the field type to number, the static_sport_id key is written but there are no corresponding value.

image
image975×313 23.6 KB

image

I am not sure how else to convert the array to text, as the object comes from an external DB and then published as a Bubble thing based on the data types set in the API connector.

If you have any other thoughts, or think there is something I am missing, please let me know.

Thanks,

Naveen

#10

Hi @naveenreddyla,

Thank you for your clarification.

Unfortunately we don’t have a similar use case on our Demo Page, I’ve escalated this question to our Development Team for further investigation.

Thank you for your patience as we work on finding a solution. I’ll keep you updated and get back to you as soon as we have more information :pray:.

Best regards :sunflower:,

Support Team
Browse all Zeroqode Plugins for Bubble
Banner_Last3

#11

Hi Mina,

It is strange. I use these array columns (from Supabase) throughout my bubble app for various forms of filtering. So I know that Bubble can see and manipulate these fields. They work fine. I suspect that Get Things as JSON plugin may be somehow confused while parsing the array field. Do you know if it is expecting a certain format?

Functionally it should pick up the array type from the Bubble API connector, and then convert to a JSON string that represents an array.

Thanks for your assistance. I appreciate it

Naveen

#12

Hi @naveenreddyla,

Thank you for your patience!

To help us investigate further, could you kindly provide a step-by-step description of the workflow you’re using? This will allow us to verify with the dev team and try to reproduce your configuration on our side. Additionally, if possible, you could record a loom video showing the workflow— that would be really helpful! Here are a few details that would assist us:

  • What is the expected output?
  • What actions are you using?
  • How are those actions set up?

Please confirm which specific action is being used, as that will help us investigate the issue more quickly :blush:

These details will help us to investigate the issue more quickly.

Looking forward to your response!
Support Team
Browse all Zeroqode Plugins for Bubble
Banner_Last3

#13

Hi @naveenreddyla,

I wanted to check in and confirm if you’ve been able to get the action working yet. Please let me know if you are still encountering any issues with the plugin. If you do, please provide me with the requested details in the previous message :pray:

I’ll do my best to help you out!

Regards,
Support Team
Browse all Zeroqode Plugins for Bubble
Banner_Last3