struggling with TextractJason

[stagliaferri1640766615]

Hello,

I am struggling with using the textractjson component to read the json file I am attaching .

I need to store in a sql table all columns under

user_segments

this is how I am setting up the compoment but I am always getting "

json string can not be null or empty"

can please someone help?

also, the "or_tags" elemnts might have more values - how can I store them all in the same column?

thanks a lot

[Anonymous]

Hi

Set the Json query expression as "id", you will be able to extract id value from the json string.

Regards

Shong