Reltio Connect

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

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.   

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