JSON Reader / hit and miss

Get Help
1

Hey @Wasay-Gumloop ,

(been a while … :wink:

Listen, I have seriuos problems with the JSON reader node.

It sometimes works, and then not …

image
image1350×1556 336 KB

I get this from Ask AI node:

image
image3446×968 348 KB

This is coorect input in JSON

image
image3534×916 248 KB

And sometimes it runs correct and all will be put in google sheet.

But every other time it crashes …

Anoying and strange …

Your thoughts are welcome

2

Hey @Donna! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

  1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

  2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
    GIF guide

  3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

3
4

Hey @Donna, I hope you’re doing well!

Completely understand the frustration here. The issue is that your JSON is using single quotes (') instead of double quotes ("). JSON specification requires all strings to be enclosed in double quotes.

Here’s an example of a corrected version:

{
  "date": "2024/03/19 08:27:38",
  "date_number": "19032024",
  "dimension": "500.0 um",
  "id": "A003",
  "magnification": "101.5 x",
  "resolution": "2592x1944",
  "text": "DL0 L=549.044 um",
  "unit": "um"
}

If you explicitly specify this in your AI prompt like below, you should be all set!

Example:
"Make sure the JSON is using double quotes, and not single quotes. Output just valid JSON, without any JSON backticks. "

Let me know if this makes sense and works for you :slightly_smiling_face:

1 Like
5

This topic was automatically closed 20 days after the last reply. New replies are no longer allowed.