Hi Daniel,
Thanks a lot for the suggestion. For now we are trying to establish a connection with the Excel connector and have reached out to our admin team. Once the connection is established , I will run this approach and will update you.
Regards
Aditya Gupta
------------------------------
Aditya Gupta
Freshgravity
------------------------------
Original Message:
Sent: 06-05-2024 08:30
From: Daniel Gage
Subject: RIH: How can we decode a downloaded .xlsx file using the SharePoint connector?
Direct support for parsing Excel files is best handled through the Excel specific connector. This connector does require that the data is stored in OneDrive or Sharepoint. Since your data meets this requirements you should be able to use the Get Rows action directly. If the Excel file is in another repository then you may need to use some scripting like the JavaScript component to parse the source data.
------------------------------
Dan Gage
Principal Solution Consultant
Original Message:
Sent: 05-21-2024 09:19
From: Aditya Gupta
Subject: RIH: How can we decode a downloaded .xlsx file using the SharePoint connector?
Hi All,
We are using the Sharepoint Connector to download a .xlsx file from Sharepoint into the recipe. We can download the file, but it appears to be in an encoded format. In order to parse the data, we need to decode it to CSV or JSON format.
Has anyone worked on sharepoint connector and decoding the .xlsx file after its downloaded?
Thanks
Aditya Gupta
------------------------------
Aditya Gupta
Freshgravity
------------------------------