Answered
How Can I fetched multiple files from google drive using Celigo?
How Can I fetched multiple files from google drive using Celigo?
0
How Can I fetched multiple files from google drive using Celigo?
Comments
Moving this to our main community forum, rather than the area for enhancement requests.
HI,
Let me know how can I access it after moving to main community
It should be super simple to do this.
Please be more specific if you have a more targeted use case. Also, it is really helpful if you provide more background on what you are trying to do, and screenshots where you are getting stuck, etc...
If are looking for more guided help, then please contact support, or attend one of our office hours sessions.
Hi Scott,
I am good with drive connection. Here I am creating some files on google drive and also files are uploading via flow successfully. But I also want to fetched the file link/url created on google drive in order to send it to another system.
there could be multiple files so file id will not help as the base/common url is changing every time for every generated file.
I am not an expert with google drive APIs, but i would think the base url is common for all files in your google drive, and then only the id for a file is unique, and then it should be easy enough to construct the url to send to other apps. i.e. To get the id back into your source record payload you would define a 'Response mapping'. I actually recommend mapping both 'id' and '_json' back into your payload, and the '_json' field can sometimes contain useful info (depending on what the external API returns).
Hi Scott,
I applied response mapping in the flow and trying to fetch id as well as other values as below
But here we are not getting any ID back, we are getting _JSON data only which contains file name. Nothing else we have in data which I errored out manually by adding some error in flow.
for sample see below data :
{
"errors": [
{
"occurredAt": "2022-08-12T00:21:37.236Z",
"source": "post_submit_hook_ss",
"code": 200,
"message": "Unable to create the order in NetSuite for the Shopify order #4762883915863 Failed to save record because Please configure the inventory detail for this line.",
"traceKey": "4762883915863",
"importDataURI": "https://radpowerbikes.ca/admin/orders/4762883915863",
"oIndex": "1",
"retryDataKey": "e5c3c2ee93af4ef3886d2882fa954468",
"errorId": "921318424",
"_flowJobId": "62f59cdeb2715028f2e2df6d",
"reqAndResKey": "5597854702616-f6c72669210f4be4bd4ee39079154a83-undefined-undefined",
"json": {
"name": "file-2022-08-12T08:49:34-07:00.xlsx",
"fileLocation": "Createdfile"
}
}
]
}
Bummer. I was hoping we would have the id from Google available in the response data. I will pass this along to our team to enhance.
Hi Scott,
Any update here?
Hi Shamali Raut
I'm working with my team to see if there is any way to get around this issue. Please give me until today to keep you updated on the status.
We have created an enhancement request to address this issue and ensure that we capture the entire raw response in '_json" field (JSON format) so that any field returned by an API can be accessed in the flow response mapper. We are currently scoping the details for this enhancement.
Thank you & Regards,
Pridhvi
Hi Shamali Raut,
After internal team discussions, we determined that there is no simple solution to this problem at this time. As I mentioned in my previous comment, we intend to improve this in the first half of next year, though the exact date has yet to be determined. I will keep you updated once we have prioritised this issue. Thank you very much.
Regards,
Pridhvi
Please sign in to leave a comment.