Forum Discussion
Extract records from Excel file
Is it possible to extract data from an Excel file that is stored in a list? I am connecting to the data source via an API, and in one of the columns, the user is attaching a spreadsheet with more inf...
Given your scenario, the steps to access and extract data from an Excel file stored in a list via an API typically involve:
> Connect to the API: Home tab → New Source → Web → provide the API URL.
> Authenticate (if required): Follow the prompts to authenticate with the API.
> Navigate the JSON response: Locate the column with the file, and extract the URL or binary data for the Excel file.
> Connect to the Excel file: If you have a URL, use New Source → Web again with the file's URL. If it's binary data, use the "From Binary" transformation.
> Extract the needed data: Select the relevant sheet and data range within the Excel workbook.
if that helped, please upvote me!!