Extract values in Object type using any tjava component

[heshkaru]

Hi,

Can I check whether '

purchase_order_details_notes' is null or not. Below Object is getting as the output if I log. Can I extract values separately.

[{"item":"2285542","purchase_order_details_notes":[{"note_line":"1"}]}]

Thank you

[Anonymous · Accepted solution]

Hello,

You are able to consume your data using a tFileInputJSON component and then connect the output to a tLogRow for testing only.

After that, the data extraction can be go with tExtractJsonField components.

Best regards

Sabrina