adding data from JSON dataset to an existing PDF document automatically saving a copy for sharing

[Steve365978058ymn]

Hi, 

I'm new to this community so forgive me if I'm asking to wrong forum.
We have a bunch of PDF documents that people are filling in manually - what we've been asked is can this be automated. I've already been down the web form route, and although I like the result, I have to pass all the data in via the URL, and this only works for a 1-1 , not a 1-n scenario.
I've done some research into Power Pages with Power Automate too , but this seems to only allow merging of data into a Word Template.

Ideally, what we would like to do is: From with our in-house web application, click a button/link and a request would be sent with all the necessary data in a JSON payload - this would be merged into a pre-existing PDF, and saved into a cloud repository , like sharepoint, and a URL returned. 
Hopefully, we can then allow add e-sign onto this, so the document can be shared with the customer and they can e-sign it.
What I'm struggling to grasp is the high level parts required to achieve this. Regarding the repeating 1-n data, I have considered whether this could be a separate document that is then merged with the base document. I would prefer to avoid recreating the PDFs in Word, if at all possible.

any pointers, gratefully received.

[try67]

This is probably possible using a custom-made tool. Certainly not with Acrobat.

[Steve365978058ymn]

I solved this by using MS Power Automate - it does require me to save the PDF as a Word Template, but then I can merge the data into it, and then recreate it as a PDF using appropriate connectors.

Regards,

Steve

[irene_7843]

Hi, I have been struggling to do the same thing. My PDF template is not exactly line by line, a mess of fillable parts. Wonder if you can share your general flow template? Thank you very much!

[Thom Parker]

This sounds like a web based (variable data?) solution, not an Acrobat(desktop) based solution.  

Unfortunately Adobe doesn't offer a web based form filling tool (except for AEM). There is of course the PDF API (not Acrobat) and there are several 3rd party libraries and tools (ActivePDF comes to mind) that can be used for this.

But if you are looking for a desktop variable data solution, look at EverMap. 

[Steve365978058ymn]

Hi, thanks for the the reply, I wasn't sure which of the suite of Adobe applications might provide a solution - I'd briefly checked out AEM, but i don't think our licensing covers that. I was hoping that it was more my inexperience with the products, and not knowing how to best leverage the applications.
I might have to look into AEM further.

Many thanks.

Steve