Skip to main content
Richtpt
Richtpt
Inspiring
March 23, 2022
解決済み

How to parse JSON output from Adobe Services Extract in Microsoft Power Automate

  • March 23, 2022
  • 返信数 2.
  • 3134 ビュー

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" in a Microsoft Power Automate Flow.  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:

 

 

 

 

このトピックへの返信は締め切られました。
解決に役立った回答 Richtpt

I have figured this out.

 

I have a Compose action to convert the Extract output - base64ToString(output).

A second Compose to convert that to JSON.

Then a select to get the 'elements' values I need.

返信数 2

Ben Vanderberg
Community Manager
Ben VanderbergCommunity Manager
Community Manager
April 8, 2022

Glad here you found the solution. The other option is you can use Extract PDF Structure in a JSON Object, which will return in the body the JSON that you can then use a Parse JSON action to use in the rest of your flow.

G
Gregg29246193r2f7
Participant
April 4, 2023

I have a similar flow - using the Extract to JSON (both object and tried with file) but when I inspected the contents of the JSON text, I do not see any values that were supplied to the fillable PDF. Searching for things known in the PDF (an amount field, name field, signature printed field) and nothing seems to be getting extracted. Any thoughts on why this is?

J
jeffPCS
Participant
October 31, 2024

Same as of today. Elements returns null after parsing JSON using the Adobe extract schema.

Richtpt
Richtpt作成者解決！
Inspiring
March 23, 2022

I have figured this out.

 

I have a Compose action to convert the Extract output - base64ToString(output).

A second Compose to convert that to JSON.

Then a select to get the 'elements' values I need.

    J
    jeffPCS
    Participant
    October 30, 2024

    Long shot here...But would you be able to show your whole flow? I'm stuck where you were but not following your compose actions. I get expression not valid.

     

    契約条件Accessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices