Source is not valid JSON issue

How To
,
1

Hello I have this scenario which i grab info from a newsfeed builder, it strips the required info sends it to ChatGPT to then provide an output into google sheets.

However going though the set up i face the Source is not valid JSON issue. it worked then all of a sudden didnt and i changed nothing.

Scenario
inoreader > array aggregator > iterator > HTTP make a request (pulls URL from the iterator, method is GET, body type raw , content type XML (text/xml) > Text parser match pattern (pattern is <body[^>]>([\s\S]?)</body> and the text field is the data from HTTP module > text parser HTML to text (pulling the previous text parser which is $1) > openai to pull the info together > JSON parse json (in the json string it is the content from open ai) > Google sheets

the YT tutorial is here that i followed to set up this scenario https://www.youtube.com/watch?v=jfv6Y6bRTt4&t=614s

Can anyone help with getting the JSON parse JASON to stop throwing a error out please

image
image2618Ă—428 83.6 KB

2 Likes
2

Heyy @Katie_Howe ,

Follow steps mentioned here to resolve this error.

Best,

@Prem_Patel

3

What is the output of module 7?

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490Ă—338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Add three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight and click the “preformatted text” button in the editor —

  • Method 3: Upload your file and share the public link —
    (this method is only recommended for large files exceeding the forum upload limit)

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.

This will allow others to better assist you. Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew