CSV - Parse

Overview

The 'CSV - Parse' action parses the contents of a CSV file and returns it as JSON data.

Example Flow

Please refer to the following article showcasing the 'CSV - Parse' Power Automate action: Parse a CSV File and Add Content to a SharePoint List

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Parameters

The default 'CSV - Parse' flow action parameters are detailed below:

  • File Content: A Base64 encoded representation of the CSV document

Advanced Parameters

The advanced 'CSV - Parse' flow action parameters are detailed below:

  • Delimiter: Override the character used to delimit the CSV file. The default value is a comma.  For a tab delimiter enter \t
  • Column Headers: Optional - Manually override the columns headers for the CSV file as a comma-separated string e.g. Col1, Col2, Col3. Column headers will be automatically determined if a value is not provided.
  • Skip First Line: If 'Yes', the first line of data is pulled from the 2nd line.

Return Parameters

The 'CSV - Parse' flow action returns the following data. 

Action Specific Return Values

  • CSV Data - The contents of CSV file parsed as JSON.

Standard Return Values

  • OperationId - The unique ID assigned to this operation
  • HttpStatusCode - The HTTP Status code for the response
  • HttpStatusMessage - The HTTP Status message for the response
  • Errors - An array of error messages should an error occur
  • Operation Status - Indicates whether the operation has been completed, has been queued or has failed
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk