parse specific object type in JSON array

[stagliaferri1640766615]

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 · Accepted solution]

Hi

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

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

 

Regards

Shong

[stagliaferri1640766615]

Hello,

thank you very much! it worked perfectly.

[Anonymous]

Glad to hear, thanks for your feedback!