+12I have a table that I need to export and save to sharepoint as a csv file. I'll need to do it once a month.
Is there a way to do this via pipelines without having to export to file to a shared drive and then upload it to sharepoint?
Thanks.
Best answer by ChayceDuncan
The pipeline has it in the step output from your query. So in a simple example Step A in your pipeline would be to download contents to CSV, then Step B would be to take that download and add to Sharepoint. The output from A in the pipeline looks like below which includes that file_transfer_handle that you would use as the 'source' for the upload to Sharepoint.
+9This should be doable, yes, depending on how large the dataset is.
The process I would try and follow is to use the Quickbase Channel to Export Records to CSV, where you would provide a subset of columns or include them all and provide the query (or nothing for all records).
That would give you a csv file object that you can then pass into the Sharepoint channel to then upload a file to the designated spot in Sharepoint you need it to go.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
