App script integration with PDF.co

[Harriswe]

Using an app-script to merge PDF files although the script originally used a Google sheet to pass parameters. However using a Bot to pass parameters to the app-script there is a problem receiving the resulting merged file URL back.

Q: How to you specify a URL path for 3rd party apps like PDF co to store a file, which is relative to where where AppSheet app stores files?

Q: Has anyone had any success using something like PDF.co with AppSheet?

Thank you for any assistance.

[SkrOYC]

@Harriswe

How to you specify a URL path for 3rd party apps like PDF co to store a file, which is relative to where where AppSheet app stores files?

I’m sorry, can you explain this better? You need a place to save a URL that’s part of the response or you need to pass the file as a URL for them?

[Harriswe]

Parameters sent to the 3rd party routine are:

1. ListPDFURLS: List or URLS (represents the list of PDF files to merge)
2. MergedURL: Return is the URL to the merged File

To save the merged file somewhere where you can retrieve it, you need to save the file to a specified location. My question was how do you specify a location that is relative to Google Drive where the AppSheet app is running?

[quote=“SkrOYC”]

@Harriswe

wrote:> > How to you specify a URL path for 3rd party apps like PDF co to store a file, which is relative to where where AppSheet app stores files?

I’m sorry, can you explain this better? You need a place to save a URL that’s part of the response or you need to pass the file as a URL for them?

[/quote]>
Something along the lines of the following:

**

• Save file URL to specific location
  */
  function uploadFile(fileUrl) {
  var fileContent = UrlFetchApp.fetch(fileUrl).getBlob();
  var folder= DriveApp.getFolderByIdAndResourceKey("********);
  folder.createFile(fileContent);
  }

Thank you for assisting.