topic parse specific object type in JSON array in Talend Studio

parse specific object type in JSON array

stagliaferri1640766615 — Fri, 15 Nov 2024 21:55:55 GMT

Hello community,

I am parsing a JSON which contains this array:

"attachments": [

{

"filename": "CoverLetter.docx",

"url": "",

"type": "cover_letter",

"created_at": "2022-02-03T19:09:12.839Z"

{

"filename": "Resume.pdf",

"url": "",

"type": "resume",

"created_at": "2022-02-03T19:09:12.602Z"

{

"filename": "image.jpg",

"url": "",

"type": "image",

"created_at": "2023-02-27T13:01:04.786Z"

}

]

I am using a tExtractJSON compoment.

on attachment array might have a lot of items , and I am only interested in retrieving the "type": "resume".

Is there a way to filter and retrieve only

"type": "resume". ?

thanks a lot!

Anonymous — Mon, 10 Apr 2023 07:28:06 GMT

Read by 'JsonPath' model and add the filter expression in loop jsonpath field. eg:

$.array[?(@.type=='resume')]

Regards

Shong

stagliaferri1640766615 — Mon, 10 Apr 2023 09:51:09 GMT

Hello,

thank you very much! it worked perfectly.

Anonymous — Mon, 10 Apr 2023 14:10:03 GMT

Glad to hear, thanks for your feedback!