Hi All,
I have requirement where i want to create records from the data present in Excel file which is stored as attachment in notes or file type field of entity .
right now when I am trying to get data using Download file or image content connector it is fetching the data in binary content like below:
Now i want to convert or data in json array or object so that i can create a loop call for creating records based on the data which is present in the Excel file .
I also tried to achieve this through JavaScript but there also i get data in base64 , no idea how to convert that into json array(code-https://debajmecrm.com/retrieve-contents-of-file-data-type-field-in-dynamics-365-cds-using-javascript-client-code/)
Can anyone help me to convert or better approach for creating records from the attached file in CDS....?


Report
All responses (
Answers (