Skip to main content

How Can I fetched multiple files from google drive using Celigo?

Answered

Comments

11 comments

  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Moving this to our main community forum, rather than the area for enhancement requests.

    0
  • Shamali Raut

    HI,

     

    Let me know how can I access it after moving to main community

     

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    It should be super simple to do this.

    1. Create a flow.
    2. Select 'Google Drive'.
    3. etc...

    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.

    0
  • Shamali Raut

    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.

    0
  • Shamali Raut

    there could be multiple files so file id will not help as the base/common url is changing every time for every generated file.

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    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).

     

     

    0
  • Shamali Raut

    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"
          }
        }

    ]

    }

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    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.

    0
  • Shamali Raut

    Hi Scott,

     

    Any update here?

     

    0
  • Pridhvi Product Manager
    Answer Pro
    Great Answer

    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

    0
  • Pridhvi Product Manager
    Answer Pro
    Great Answer

    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

    0

Please sign in to leave a comment.