Skip to main content
Question

Pipeline to import an .xlsx from a watched folder in OneDrive

  • February 22, 2022
  • 0 replies
  • 100 views
Forum|alt.badge.img+6
Hello QB Folks!

I've done a bunch of looking around, and can't see an out-of-the-box solution.

I get a couple of excel files (in .xlsx) a day that I load into specially-set up staging tables in my quickbase.  From there, I have pipelines moving the data into other parts of my app.

I'd love to figure out how to drop the file into a watch folder in OneDrive, and have the rows loaded as-is into my staging tables. I can see the OneDrive pipeline, but it doesn't seem to have a function to process the contents of a file.


------------------------------
Malcolm McDonald
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • February 22, 2022
I'm trying to sort out the similar thing. If you can use a CSV I think you can sync to dropbox or Box, but I'm not sure about oneDrive.

I know @Juiced Tech has some add-ons that possibly can help with this type of thing. But I'd be curious to find out if you come up with a native solution.
​

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement