How to parse JSON output from Adobe Services Extract

[RichardUchytil]

We are wanting to parse a PDF email attachment, extracting specific text and putting it into a SQL Server database. 

I'm using Adobe Services "Extract PDF Structure in JSON File".  The output is outputs('Extract_PDF_Structure_in_a_JSON_File')?['body/jsonFileContent'], which is unreadable.  How do I convert that to something I can work with?

Also, I was able to output that to a JSON file.  I don't know much about JSON.  When I open the file in Notepad++ I see there are four sections, "pages", "extended_metadata", "elements", and "version".  I only need the data in the "elements" section, and that section is a JSON array.

In the "elements" array the fields I need are all called "Text":

Any suggestions how to get this data so I can put it into a database?  Thanks!

Here's my flow:

And the run:

[Manar]

Hi @RichardUchytil ,

Try base64 

https://debajmecrm.com/binary-to-base64-in-microsoft-power-automate-microsoft-flow/ 

[RichardUchytil]

Great!  That changes it into readable text!

But now how do I tell my flow to only use the array in the "elements" section?

[RichardUchytil · Accepted solution]

Figured it out!!  I have a compose that does base64ToString, a compose that converts that to JSON, then a select that pulls out the value I need.

Here's the flow:

First Compose:  base64ToString(outputs('Extract_PDF_Structure_in_a_JSON_File')?['body/jsonFileContent'])

Compose 2: json(outputs('Compose'))

Select From: Outputs('Compose_2')['elements']

Map: item()?['Path']

         item()?['Text']

The output of the Select:

Now I've got data I can insert into SQL Server!  Thanks very much for the base64 tip!

[SandraSoniec]

The PDF structure is stored as string in the structuredJsonObjectKey

I have used the following Compose action to retrieve the values of interest. Was then able to select the values I need in dataverse. 

json(outputs('Extract_PDF_Structure_in_a_JSON_Object')?['body/structuredJsonObject'])