Hello,
I am using JSON Reader to read some data, however, the node only takes the first record of data. is there any feature in the node that I need to activate or change? Do I need to run the whole process via a loop? if yes, what loop I need to use? any examples that you can share, please?
Hello @spiltan
The image that you posted, it’s showing a JSON’s preview view from ‘JSON Reader’ config.
Aiming to parse the JSON content, you will need to use some other nodes downstream. Typically these two:
For further support, you may have to provide some challenge details or share some sample data.
BR
Here is what I used:
but I still see one row of data. Is there anything wrong with my logic? I tried to use loops, but it still gives me the same results. I used the loop after JSON reader node.
Hello @spiltan
It’s hard to know from a capture.
I think is all about the query configuration within your ‘JSON Path’ nodes.
Can you check in your queries if the query type is single or collection?
You may have to config collection queries for all of your calls.
BR
thank you so much for your response!
my JSON file shows 17k plus Ln when I am opening it in note, but it only reads the first Ln in JSON reader.
I have multiple “data”, each row of data has multiple “companyIds”, “Ids”, values and other fields.
I use JSON Path and Ungrouping nodes, but it only gives me the first ln of “data”. I am not sure how to tackle this. I tried to use loop but it did not work.
here is a sample data:
{“data”:{“code”:“Test 1”,“companyId”:“1f465168-3829-4a32-ba0a-f28a2ca39213”,“id”:“a626d73a-94fe-af41-9eb3-32d63187e740”,“isDeleted”:false,“labels”:[{“id”:“bac1d137-fd78-6746-971e-09447e1ed241”,“isLocalized”:false,“langCode”:“bg”,“lastModifiedDate”:“2023-09-19T20:10:00.947+00:00”,“value”:“Test 1”}],“lastModifiedDate”:“2023-09-19T20:10:00.943+00:00”,“level”:1,“lists”:[{“hasChildren”:false,“id”:“87a45548-546a-b74b-bdd6-c81bf4685489”,“lastModifiedDate”:“2023-09-19T20:10:00.963+00:00”}],“shortCode”:“Test 1”,“timestamp”:“2023-09-20T02:10:08.186Z”},“type”:“list-item.1970-01-01T00:00:00Z.upsert”,“time”:“2023-09-20T02:10:08.186Z”,“id”:“1f465168-3829-4a32-ba0a-f28a2ca39213.a626d73a-94fe-af41-9eb3-32d63187e740”}
{“data”:{“code”:“Implementation-C03-D05-CC02”,“companyId”:“1f465168-3829-4a32-ba0a-f28a2ca39213”,“id”:“26763a62-06ce-c440-9343-bc9a63544846”,“isDeleted”:false,“labels”:[{“id”:“8c6d3314-2ea4-5e4c-bbb4-155ec927c94e”,“isLocalized”:false,“langCode”:“bg”,“lastModifiedDate”:“2023-11-17T15:59:37.907+00:00”,“value”:“Cost Center 02”}],“lastModifiedDate”:“2023-11-17T15:59:37.903+00:00”,“level”:4,“lists”:[{“hasChildren”:true,“id”:“cb2b9137-9c42-0343-aeaa-3daf19301538”,“lastModifiedDate”:“2023-11-17T15:59:37.907+00:00”}],“parentId”:“e02e106d-e137-604f-aa4f-d35b54edfda2”,“shortCode”:“CC02”,“timestamp”:“2023-11-17T21:58:54.423Z”},“type”:“list-item.1970-01-01T00:00:00Z.upsert”,“time”:“2023-11-17T21:58:54.423Z”,“id”:“1f465168-3829-4a32-ba0a-f28a2ca39213.26763a62-06ce-c440-9343-bc9a63544846”}
Hello @spiltan
This sample data is returning a reading error.
could you please test the sample data, and share it as validated.
Thx. in advance.
