Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Alteryx Server Knowledge Base

Definitive answers from Server experts.

How to Pass in Excel Worksheet Name in the Gallery API

clarab
Alteryx
Alteryx
Created

How to Pass in Excel Worksheet Name in the Gallery API


File Browse tool is now supported in Gallery API with the new endpoint - /user/v2/inputfiles in version 2020.3 that allows you to upload a file followed by /user/v2/workflows/{appId}/jobs endpoint to submit the job.
 

Prerequisites

 
  • Alteryx Server 
    • Version 2020.3 and above
 

Procedure

1. Use [POST] /user/v2/inputfiles endpoint to first upload the Excel file. 
2. Use the returned reference Id from the [POST] /user/v2/inputfiles endpoint in the questions JSON payload of [POST] /api/user/v2/workflows/{appId}/jobs endpoint.
3. To include the sheet name, add in three pipe characters (|||) followed by the name of the sheet after the reference Id.
 
Example:
{
  "questions": [
    {
      "name": "File Browse (4)",
      "value": "603770dfb36f00008d002d97|||`Sheet1$`"
    }
  ]}
}

"File Browse (4)" is the name of the File Browse tool in the application. "603770dfb36f00008d002d97" is the reference Id from Step 1. "Sheet1" is the name of the Excel Worksheet to use.
 
 

Additional Resources

 

No ratings