Why it gives these error The key 'ad_id' was not found in the JSON object. when I give JSON Reader a JSON file, Even if there is ad_id is there in it's input

[Elish]

https://www.gumloop.com/pipeline?workbook_id=6segLFF1BYA3PnsfcCYBWM&run_id=ktDVLEnu6CG3xcnocvvtyp

[Wasay-Gumloop]

Hey @Elish - The JSON Reader node works with a single JSON String at a time. https://docs.gumloop.com/nodes/json/read_json_values

The JSON data you’ve provided is structured as an array of objects, each containing ad information. This is indicated by the square brackets [ ], so you need to first extract individual objects from it.

It might also be worth it to look into creating a simple custom node that can parse the JSON Array directly. The AI in the custom node builder should help you build it.

Doc: https://docs.gumloop.com/nodes/custom_node_details
Video Tutorial: https://www.youtube.com/watch?v=yHjxbmdg-cI&ab_channel=Gumloop
Custom Node Workshop: https://www.youtube.com/watch?v=ovCCWfgWv4M

Let me know if this works for you.

[Elish]

@Wasay-Gumloop Thank you! now it is working

[mikban]

Thanks for this response Wasay! I’ve personally struggled with this a bunch so its nice to have more docs about this

[Wasay-Gumloop]

No problem!