Example how to parse a JSON file and use where and pluck to extract specific data

gfranco — Tue, 11 Feb 2025 22:04:18 GMT

I am following along on the training in Automation Pro III, I completed the part of the CSV file and at the end, you can logger the data in the Workato app.

I want to follow the same scenario but using a JSON provided, but I do not have an idea after configuring the JSON document what else I should do.

1. Trigger scheduler

2. Parse Json document

use where('country': "FRANCE).pluck('email')

3. Log message to job report

I appreciate your help.

Re: Example how to parse a JSON file and use where and pluck to extract specific data

shivakumara — Wed, 12 Feb 2025 08:26:55 GMT

Hi @gfranco ,
Here’s my understanding based on the given requirements for the main logic:

Parse the JSON data and filter it based on the Country field, then log the filtered data.

Solution:

Pass the required data as-is in the Parse JSON step (both sample and actual documents).
Use a Formula to extract the filtered data (e.g., where('country': "FRANCE").pluck('email')).
Double quote should there for [Example: "Country", "FRANCE", "email"]

Parse JSON: This component is used to extract incoming data based on the provided sample document.
Thus, it's best to apply the Formula after the extraction step 2 in your case.

Thanks and Regards,
Shivakumara K A

topic Re: Example how to parse a JSON file and use where and pluck to extract specific data in Workato Pros Discussion Board

Example how to parse a JSON file and use where and pluck to extract specific data

Re: Example how to parse a JSON file and use where and pluck to extract specific data