Question

How can I retrieve data from the .xlsx file in Sharepoint and upload it to Printavo using Zapier?

  • 21 October 2023
  • 1 reply
  • 132 views

Hello and Thank You,

I am trying to set up a Zap that pulls the information from the first worksheet in a .xlsx file when it is uploaded to Sharepoint, converts the rows to line-items, and then uploads it to my order management system, Printavo.  The trouble I am having right now is that I don’t know how to actually retrieve the information in the .xlsx file once it is uploaded to Sharepoint.  Any help would be much appreciated!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @rshenk3 

Good question.

You’d likely have to use Microsoft APIs for SharePoint and Excel.

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-rest-api

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=csom