To automate tasks within the Workiva platform as part of a chain, such as to enable the exchange of data with other data sources, add a step that includes a Workiva connection command.
To enable these commands, an IT admin first sets up a Workiva connector.
Clear Sheet Data
To clear all data in a sheet, use a Clear Sheet Data command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier for the spreadsheet with the sheet to clear. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to clear. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create File
To upload a comma-separated values (CSV), Javascript object notation (JSON), or compressed ZIP file and lists its records, use a Create File command. You can also upload the URL to the file, such as an Amazon S3®-signed URL to a file in an S3 bucket.
- If a JSON file, it must have a single JSON record per line—a JSON file is a series of JSON objects delimited by a newline character.
- If a ZIP file, it must contain a single CSV or JSON file, whose name is used to name the imported file. Downloading the file again downloads the source.
- If a URL, the endpoint makes a request to get a file using a simple unauthenticated
GET
request.
Properties
Property |
Detail |
Table ID |
Enter the ID of the table to list the files of. |
File |
Enter the file to upload. Ignored if Download URL is entered.
Note: The file must have a .CSV or .JSON extension, or be a ZIP file that contains a file with a .CSV or .JSON extension.
|
Name |
If Download URL is entered, enter the name of the file to upload; by default, the base name of Download URL. |
Download URL |
Enter the URL that points to the file to download, such as an Amazon S3-signed URL. Optional if File is entered.
Note: The command makes a simple GET request against the URL, with no authentication.
|
Outputs
Output |
Output Type |
Results |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Pivot View
To create a new Wdata view given its query and query result, use a Create Pivot View command.
Properties
Property |
Detail |
Name |
Enter a unique name to help identify the view. |
Query ID |
Enter the ID of the query to create the view from. |
Query Result ID |
Enter the ID of the query result to create the view from. |
Additional Metadata |
Enter the user-defined metadata to attach to the view as a JSON object (optional). |
Outputs
Output |
Output Type |
Pivot View |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Preview Query
To create a temporary preview query on a table that can then be executed, use a Create Preview Query command.
Properties
Property |
Detail |
Table ID |
Enter the ID of the table to query. |
Limit |
Enter the maximum number of results to return. |
File |
If specified, enter the name of the file in the table to query. |
Outputs
Output |
Output Type |
Query |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Query
To create a new Wdata query, use a Create Query command.
Properties
Property |
Detail |
Name |
Enter a unique name to help identify the query. |
Description |
Enter a description of the query. |
Primary Result ID |
If specified, enter the ID of the default result to populate with the query results. |
Query Text |
Enter the query definition as Presto SQL syntax, as you would in the query's SQL Editor. |
Temporary |
To generate the query temporarily so it does not appear in your workspace, check this box. |
Parameters |
Enter the parameters required to run the query. |
Outputs
Output |
Output Type |
Query |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Record
To create a new record in your organization's SOX and Internal Audit database account, use a Create Record command.
Properties
Property |
Detail |
Record Kind |
Enter the kind of record to create |
Properties |
Enter the properties to set or change on the record |
Outputs
Output |
Output Type |
Edit Reference |
File |
Record ID |
String |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Sheet
To add a new sheet to a spreadsheet, use a Create Sheet command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to add the sheet to. |
Name |
Enter a unique name to help identify the sheet. |
Sheet Index |
Enter the index of the new sheet within the spreadsheet.
Note: By default, the command adds the sheet as the top sheet.
|
Parent Sheet ID |
Enter the ID of the parent sheet to create the sheet under. To add to the root spreadsheet, leave blank. |
Outputs
Output |
Output Type |
Sheet Metadata |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Spreadsheet
To create a new spreadsheet, use a Create Spreadsheet command.
Properties
Property |
Detail |
Name |
Enter the unique name to help identify the spreadsheet. |
Outputs
Output |
Output Type |
Sheet Metadata |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Create Table
To create a new Wdata table in your workspace, use a Create Table command.
Properties
Property |
Detail |
Name |
Enter a unique name to help identify the table. |
Description |
Enter a description of the new table. |
Type |
Select whether to create a Data or Lookup (or dimension) table. |
Columns |
Add the columns to include in the table. For each column, enter its name, data type, alias, and description. For Mode, leave the default of Nullable. |
Outputs
Output |
Output Type |
Table |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete File
To delete a file from your Wdata workspace, use a Delete File command.
Properties
Property |
Detail |
File ID |
Enter the ID of the file to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Pivot View
To delete a Wdata view from your workspace, use a Delete Pivot View command.
Properties
Property |
Detail |
ID |
Enter the ID of the view to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Query
To delete a Wdata query from your workspace, use a Delete Query command.
Properties
Property |
Detail |
Query ID |
Enter the ID of the query to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Record
To delete a record from your organization's SOX and Internal Audit database account, use a Delete Record command.
Properties
Property |
Detail |
Record ID |
Enter the unique identifier of the record to delete. |
Outputs
Output |
Output Type |
Edit Reference |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Sheet
To delete a sheet and its child sheets (recursively) from a spreadsheet, use a Delete Sheet command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to delete. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Spreadsheet
To delete a spreadsheet from your workspace, use a Delete Spreadsheet command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Delete Table
To delete a Wdata table from your workspace, use a Delete Table command.
Properties
Property |
Detail |
Table ID |
Enter the unique identifier of the table to delete |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Download File
To download a file from your Wdata workspace, use a Download File command.
Properties
Property |
Detail |
File ID |
Enter the ID of the file to download. |
Outputs
Output |
Output Type |
File |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Download Query Result
To download the results of a Wdata query to a file, use a Download Query Result command.
Properties
Property |
Detail |
Query Result ID |
Enter the ID of the query result to download. |
Outputs
Output |
Output Type |
Query Result |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Edit
To submit a list of changes to make to records in your organization's SOX and Internal Audit database account, use an Edit command. Changes can include any combination of creating records or setting or deleting their attributes or relationships.
Note: This command applies the changes as a single transaction—either all or none of the changes are applied.
Properties
Property |
Detail |
Data Payload |
Enter the JSON payload of the data to upload.
Note: Don't include the data key. This command places the payload in the data key of the JSON payload object.
|
Outputs
Output |
Output Type |
Edit Reference |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Export File to Spreadsheet
To export a file to a new or existing spreadsheet, use an Export File to Spreadsheet command.
Properties
Property |
Detail |
File ID |
Enter the ID of the file to export. |
Spreadsheet URL |
Enter the URL of the spreadsheet to export to. To create a new spreadsheet, leave blank. |
Outputs
Output |
Output Type |
Sheet Info |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Export Query Result
To export a Wdata query result to a new or existing spreadsheet, use an Export Query Result command.
Properties
Property |
Detail |
Query Result ID |
Enter the ID of the query result to export. |
Spreadsheet URL |
Enter the URL of the spreadsheet to export to. To create a new spreadsheet, leave blank. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get File Properties
To retrieve the properties of file in your Wdata workspace, use a Get File Properties command.
Properties
Property |
Detail |
File ID |
Enter the ID of the file to get properties of. |
Outputs
Output |
Output Type |
File Properties |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Pivot View
To retrieve the metadata of a Wdata view, use a Get Pivot View command.
Properties
Property |
Detail |
ID |
Enter the ID of the pivot view to get metadata from. |
Outputs
Output |
Output Type |
Pivot View |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Query Metadata
To retrieve the metadata of a Wdata query, use a Get Query Metadata command.
Properties
Property |
Detail |
Query ID |
Enter the ID of the query to get metadata from. |
Outputs
Output |
Output Type |
Query |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Record
To retrieve a single record from your organization's SOX and Internal Audit database account, use a Get Record command.
Properties
Property |
Detail |
Record ID |
Enter the universally unique identifier (UUID) or other unique string of the record to retrieve. |
Include Incoming |
To include incoming relationships with the record, check this box. |
Include Outgoing |
To include outgoing relationships with the record, check this box. |
Outputs
Output |
Output Type |
Record |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Records
To retrieve multiple records from your organization's SOX and Internal Audit database account, use a Get Records command.
Properties
Property |
Detail |
Filters |
Enter the property values of the records to retrieve. |
Include Incoming |
To include incoming relationships with the records, check this box. |
Include Outgoing |
To include outgoing relationships with the records, check this box. |
Outputs
Output |
Output Type |
Records |
File |
Record Count |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Reports
To retrieve all reports from your organization's SOX and Internal Audit database account, use a Get Reports command.
Properties
None
Outputs
Output |
Output Type |
Reports |
File |
Report Count |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Sheet Data
To retrieve all data in a specified region of a sheet, use a Get Sheet Data command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to get data from. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to get data from. |
Region |
Enter the A1 style representation of a cell or range, such as [Start Column][Start Row]:[Stop Column][Stop Row] . To have the range unbounded in any or all directions, leave off the corresponding column or row. |
Value Style |
Select whether to return the Raw or Calculated cell value. For example, if a cell's value is =1+:1 , select Raw for =1+1, or Calculated for the calculated value of 2. |
Outputs
Output |
Output Type |
Row Count |
Integer |
Data |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Sheet Metadata
To retrieve the metadata of a sheet in a spreadsheet, use a Get Sheet Metadata command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to get metadata from. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to get metadata from. |
Outputs
Output |
Output Type |
Sheet Metadata |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Spreadsheet Metadata
To retrieve the metadata of a spreadsheet, use a Get Spreadsheet Metadata command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to get metadata from. |
Outputs
Output |
Output Type |
Spreadsheet Metadata |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Table Metadata
To retrieve the metadata of a Wdata table, use a Get Table Metadata command.
Properties
Property |
Detail |
Table ID |
Enter the unique identifier of the table to get metadata from. |
Outputs
Output |
Output Type |
Table |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Type
To retrieve the definition for a specific record type in your organization's SOX and Internal Audit database account, use a Get Type command.
Properties
Property |
Detail |
Include Incoming |
To include incoming relationships with the type, check this box. |
Include Outgoing |
To include outgoing relationships with the type, check this box. |
Type Name |
Enter the name of the type to retrieve. |
Outputs
Output |
Output Type |
Type |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Get Types
To retrieve the definitions of the different record types in your organization's SOX and Internal Audit database account, use a Get Types command.
Properties
Property |
Detail |
Filters |
Enter the property values of the record types to retrieve. |
Include Incoming |
To include incoming relationships with the types, check this box. |
Include Outgoing |
To include outgoing relationships with the types, check this box. |
Outputs
Output |
Output Type |
Types |
File |
Type Count |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Health Check
To check the health of the Wdata API, use a Health Check command.
Properties
None
Outputs
Output |
Output Type |
Response |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Import File into Table
To import a file into a Wdata table, use an Import File into Table command.
Properties
Property |
Detail |
Table ID |
Enter the ID of the table to import the file into. |
File ID |
Enter the ID of the file to import into the table. |
Column Mappings |
Map each column in the file to the table's columns. |
Run Asynchronously |
To have the command run asynchronously and not wait until the import is complete before continuing with the chain, check this box. |
Tags |
To include metadata your organization tracks about the data, add tags and select their names and values. |
Outputs
Output |
Output Type |
File Import |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Import Spreadsheet into Table
To import a spreadsheet into a table and returns a file meta result, use an Import Spreadsheet into Table command.
Properties
Property |
Detail |
Table ID |
Enter the unique identifier of the table to import the file into. |
File ID |
Enter the unique identifier of the file to import the spreadsheet into (optional). |
File Name |
Enter the unique name to give the file upon import into the table. |
Spreadsheet URL |
Enter the full URL of the spreadsheet to import data from. |
Run Asynchronously |
To have the command run asynchronously and not wait until the import is complete before continuing with the chain, check this box. |
Tags |
To include metadata your organization tracks about the data, add tags and select their names and values. |
Outputs
Output |
Output Type |
File Import |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List File Errors
To list the errors associated with a file, such as due to an import, use a List File Errors command.
Properties
Property |
Detail |
File ID |
Enter the ID of the file to get errors for. |
Outputs
Output |
Output Type |
Error List |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Files
To retrieves a list of files in a Wdata table and their metadata, use a List Files command.
Properties
Property |
Detail |
Table ID |
Enter the ID of the table to get files from. |
Outputs
Output |
Output Type |
Files List |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Pivot Views
To list the Wdata views in your workspace and retrieve their metadata, use a List Pivot Views command.
Properties
None
Outputs
Output |
Output Type |
Pivot Views |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Queries
To list the Wdata queries in your workspace and retrieve their metadata, use a List Queries command.
Properties
None
Outputs
Output |
Output Type |
Queries |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Query Results
To list the available results for a Wdata query, use a List Query Results command.
Properties
Property |
Detail |
Query ID |
Enter the ID of the query to get results from. |
Outputs
Output |
Output Type |
Query Results |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Sheets
To list all sheets in a spreadsheet and retrieve their metadata, use a List Sheets command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to list the sheets of. |
Outputs
Output |
Output Type |
Sheets |
JSON |
No. of Sheets |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Tables
To lists all Wdata tables in your workspace and retrieve their metadata, use a List Tables command.
Properties
None
Outputs
Output |
Output Type |
Table List |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
List Users
To retrieve a list of details about an organization's users, use a List Users command.
Similar to an organization admin's "People View" export, the details are sorted by display name and include the users':
- Usernames
- Email addresses
- SAML IDs
- Last logins
- Workspace memberships
- Licenses and roles
Properties
Property |
Detail |
Organization ID |
Enter the unique identifier of the organization to list users for. |
Outputs
Output |
Output Type |
Users Report |
File |
Record Count |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Overwrite Sheet Data
To clear all cells in a sheet and replace them with the values provided in the file, use an Overwrite Sheet Data command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to overwrite sheet data in. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to overwrite data in. |
Data File |
Enter the CSV file containing the data to populate the sheet with. |
Delimiter |
Enter the delimiter used in Data File. |
Outputs
Output |
Output Type |
Row Written |
Integer |
Cells Written |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Publish Spreadsheet
To publish the links in a spreadsheet, use a Publish Spreadsheet command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet to publish. |
Publish All Links |
Select which of the spreadsheet's links to publish:
- To publish all links, check this box.
- To publish only links you own, clear this box.
|
Outputs
Output |
Output Type |
Message |
String |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Remove Edge
To remove an edge from a record in your SOX & Internal Audit database, use a Remove Edge command.
Properties
Property |
Detail |
Record ID |
Enter the unique identifier of the record to change. |
Target ID |
Enter the unique identifier of the associated record. |
Label |
Enter the label of the edge to remove. |
Outputs
Output |
Output Type |
Edit Reference |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Run Query
To run a Wdata query and retrieve its results, use a Run Query command.
Properties
Property |
Detail |
Query ID |
Enter the ID of the query to run. |
Parameters |
If the query has parameters defined, enter their values. |
Run Asynchronously |
To run the query asynchronously, and not wait until the query finishes to complete the command, check this box. |
Outputs
Output |
Output Type |
Query Result |
JSON |
Note: The Query Result output includes an ID, which can be used to download and export the results.
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Run Report
To run a saved report in your organization's SOX and Internal Audit database account and return its results as a CSV file, use a Run Report command.
Properties
Property |
Detail |
Report ID |
Enter the unique identifier of the report that contains the saved report. |
Preview Content |
To include a preview of the report's results in the command's log, check this box. |
Outputs
Output |
Output Type |
Report |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Set Edge
To set the edge on a record in your organization's SOX and Internal Audit database account, use a Set Edge command.
Properties
Property |
Detail |
Record ID |
Enter the unique identifier of the record to change. |
Target ID |
Enter the unique identifier of the record to associate. |
Label |
Enter a label for the edge. |
Outputs
Output |
Output Type |
Edit Reference |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Set Record Properties
To set the properties on a record in your organization's SOX and Internal Audit database account, use a Set Record Properties command.
Properties
Property |
Detail |
Record ID |
Enter the unique identifier of the record to change. |
Properties |
Enter the properties to set or change on the record. |
Outputs
Output |
Output Type |
Edit Reference |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Un-import File from Table
To un-import and remove a file from a Wdata table, use an Un-import File From Table command.
Properties
Property |
Detail |
Table ID |
Enter the unique identifier of the table to remove the file from. |
File ID |
Enter the unique identifier of the file to remove from the table. |
Outputs
Output |
Output Type |
File Import |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Update Pivot View
To update the metadata of a Wdata view, use an Update Pivot View command.
Properties
Property |
Detail |
ID |
Enter the ID of the view to update. |
Name |
Enter the new name of the view. |
Query ID |
Enter the ID of the query to create the view from. |
Query Result ID |
Enter the ID of the query result to create the view from. |
Additional Metadata |
Enter the user-defined metadata to attach to the view, as a JSON object (optional). |
Outputs
Output |
Output Type |
Pivot View |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Update Query Definition
To update the properties of a Wdata query, use an Update Query Definition command.
Properties
Property |
Detail |
Query ID |
Enter the ID of the query to update. |
Name |
Enter the new name of the query. |
Description |
Enter the new description of the query. |
Primary Result ID |
If specified, enter the ID of the default result to populate with the query results. |
Query Text |
Enter the query definition as Presto SQL syntax, like you would in the query's SQL Editor. |
Temporary |
To generate the query only temporarily so it does not appear in your workspace, check this box. |
Parameters |
Enter the parameters required to run the query. |
Outputs
Output |
Output Type |
Query |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Update Sheet Metadata
To update a metadata of a sheet in a spreadsheet, use an Update Sheet Metadata command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to update metadata in. |
Sheet ID/Name |
Enter the name or unique identifier of the sheet to update metadata in. |
Name |
Enter the new name of the sheet. |
Sheet Index |
Enter the new index of the sheet in the spreadsheet. By default, the commands updates the sheet as the top sheet. |
Parent Sheet ID |
Enter the ID of the parent sheet to create the sheet under. To add to the root spreadsheet, leave blank. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Update Spreadsheet Metadata
To update a spreadsheet's metadata, use an Update Spreadsheet Metadata command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to update metadata in. |
Name |
Enter the new name of the spreadsheet. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Update Table
To update a Wdata table's columns, use an Update Table command.
Properties
Property |
Detail |
Table ID |
Enter the unique identifier of the table to update. |
Name |
Enter the name of the table to update. |
Description |
Enter a description of the table to update. |
Type |
Select whether to update a Data or Lookup—or dimension—table |
Columns |
Add the columns to update the table with. For each column, enter its name, data type, alias, and description. For Mode, leave the default of Nullable. |
Outputs
Output |
Output Type |
Table |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |
Write Sheet Data
To write data in a CSV data set to a specific region of a sheet, use a Write Sheet Data command.
Properties
Property |
Detail |
Spreadsheet ID |
Enter the unique identifier of the spreadsheet with the sheet to write data to. |
Sheet ID/Name |
Enter the unique identifier of the sheet to write data to. |
Data File |
Enter the CSV file with the data to write to the sheet. The range of the data must not exceed the Region. |
Delimiter |
Enter the delimiter used in Data File. |
Region |
Enter an A1 representation of the cell or range of cells in the sheet to write the data to. To have the range unbounded in any or all directions, leave the corresponding column or row blank. |
Use Async |
To load the data asynchronously, such as for a large dataset, check this box. |
Outputs
Output |
Output Type |
Rows Written |
Integer |
Cells Written |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Error |