Need help mapping Array Aggregator (Binary Data) to Google Docs Template "Image URL" field

Questions
, ,
1

:bullseye: What is your goal?

Automate a PDF Report generation in Google Docs using images fetched from Pipefy (which are private) and mapping them correctly into a template.

:thinking: What is the problem & what have you tried?

I have a scenario: Pipefy > Iterator > HTTP (Get File) > Array Aggregator > Google Docs (Create from Template).

The problem is in the Google Docs module mapping. The ā€œImage URLsā€ field expects a String (URL), but my Array Aggregator contains the Binary Data (from the HTTP module) and the filename.

I tried using get(array; 1) to map the image, but I canā€™t find a valid URL property to use, only the binary data buffer. I am unsure if I can map binary data directly or if I must upload these files to Google Drive first to generate a WebContentLink.

:clipboard: Error messages or input/output bundles

The Google Docs module does not accept the binary data object as an image source. Please see the attached screenshots for the mapping configuration.

:link: Create public scenario page

na

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

img.pdf (189 KB)

1 Like
3

Itā€™s the one you put in the get a file module.

4

You should normally map the data coming from the ā€œget a fileā€ module.

5

You get the URL from Pipefy.

6

I tried to use the HTTP module because i was getting a forbidden access error, but it still didnā€™t work. I guess its related to this forbidden access from the pipe.

7

The issue with mapping the data directly from the ā€˜Get a fileā€™ module is that the Google Docs template field specifically requires an Image URL (String), so it was rejecting the binary Data bundle.

8

The reason I built the complex flow initially was that Pipefy URLs are private by default (which was causing a 403 Forbidden error when Google Docs tried to access them). still didnt maage to solve

9

But downloading it with the get a file module worked? Then just upload the file to google drive and get a url from there.

1 Like