Error while reading Jason

Hi,

I am trying to read Jason File,getting below error.

@heena_shaikh
can you please share some more details with us. Sample data and the description of what to achieve would be very helpfully.

Hi,

Please help me to understand why i am not able to retrieve the required data

I want Production company name ie:STUDIO

regards
HeenaMain.xaml (5.9 KB) project.json (977 Bytes) Sivilli JSON Output.txt (279.1 KB)

@heena_shaikh
Perfect we can help you and JSON looks fine on the first look. Now you need to tell us exactly of data you would like to extract. Production company is not contained in this format within the JSON

Hi,

from the below image i want to need “raw”: “Studio” and “raw”: “Barclays_I2341” respectively. and create a folder using these two name.

image

image

1 Like

Perfect. Give me some little time and I will revert back to you

2 Likes

@heena_shaikh
have a look here:
Main.xaml (6.5 KB)

dont forget to rewire the path to your JSON textfile

For demonstration purpose the id and trascription/raw info for each field is logged out. So in general the retrieval is showcased.

@ppr Thank you so much for the efforts.

i am getting the below output,whereas i need just two values “raw”: “Studio” and “raw”: “Barclays_I2341”

Regards,
Heena

@heena_shaikh
you can filter. But the more unclear is the intention of it: Are you interested on the field from fields where raw=Studio, Barcleya_I2341 or any other searchword? So please give some more details and we can setup such a retrieval logic.

It sounds that you are interested on values that you already know, so the retrieval intention is unclear

Hi,

I am interested in Production co. which is " Studio".

and same for Job Name which is Barcleya_I2341.

there will be many files like this so basically i want to read the Production co. and Job Name in every Jason Output.

Please find the attached file.

image

Thanks,
Heena

1 Like

@heena_shaikh
Let me repeat your requirements to check my right understanding:

from all fields/field you are interested on the value of field/name where the value of field/transcription/raw=Studio or Barcleya_I2341 or maybe any other seachword, Right?

If my undrstanding is right so I will rework on the demo xaml and revert back to you

yes very much … .thanks

@heena_shaikh
PFA updated Demo XAML:
Main_V2.xaml (8.5 KB)

Searchkeys you can configure here:
Variable Panel - grafik

It is defensive implemented on occurence. does mean if for a particular searchkey more fields/field items are retrievied it will handle / demo logging all of them

2 Likes

@ppr. . .Thank you so much it is almost the solution.
But filter keys are not constant they can change as per PDF ie: Production co. and JOb name can be different in different PDF. and i have to get that dynamic value

Regards,
Heena

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.