08-25-2019 11:30 AM
Hi Team,
I am trying to write a file into google drive using REST Post snap, while creating the file in google drive, filename is set to untitled, tried with other options as such as multipart file upload but unable to resolve the error.
Below is my Rest post configuration
Below is my REST OAuth2 Account config:
any help on this issue is very much appreciated.
Thanks,
Reddy
09-09-2019 11:25 AM
I noticed that in your screenshot, all of the settings beginning with “Single file upload” are blank, including “Single file upload: Filename to be used”. Did you try setting those?
09-09-2019 11:52 AM
Hi Taylor,
Yes, I have tried that option it is working for me I am able to upload the file, but the file is getting created as “untitled”
10-08-2019 07:18 AM
Using @tlikarish’s suggestion of setting this up as a resumable upload rather than multipart/related, I was able to get this working. The pipeline is a REST POST used to create the resumable upload UIR followed by a REST PUT that uploads the file to the URI.
Red boxes indicate the fields you need to configure and how I configured them. Since this is a basic demonstration pipeline you will need to modify it to account for your needs, such as paramaterization. Note that the file does not upload in the REST POST snap.
Here are the Query Parameters and HTTP Headers set based on Google’s documentation:
Here is the REST PUT snap which uses the $response.headers.location URI from the REST POST to upload the file. That link will contain a token to ensure the file data is associated with the metadata we previously sent via REST POST.
Here is a screenshot of the file going into my Google Drive with the correct name.
Finally, there is a caveat to this approach: the multi-part form data included by the REST POST snap is added to the file (rows 1-4 and the last row, row 8 in this example).
Here is the pipeline and sample test.csv file:
REST_TO_GOOGLE_DRIVE.slp (17.6 KB)
test.csv.zip (908 Bytes)
I’ll provide another update if I can find a way around the additional HTTP Body information making its way into the file.
10-08-2019 07:41 AM
@rsramkoski, thanks for the details. I will try this approach as well. We have also worked with one of the Snaplogic developer Denver on this couple days ago and with his approach we need to post the files metadata as well as file in REST Post snap and this approach is also working. I will post the details here shortly.
Thanks,
Reddy.
09-09-2019 11:51 AM
@ptaylor I have tried setting those but still, the file was saved as an untitled.