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 fact) or Lookup (or dimension) table. |
| Columns |
Add the columns to include in the table:
- To manually add columns, click Add for each column, and enter its name, data type, alias, and description. For Mode, leave the default of Nullable.
- To add the columns' details as JavaScript Object Notation (JSON), enable Variable, and enter the JSON object or variable.
|
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 pivot view
To download the contents of a view, use a Download Pivot View command.
Properties
| Property |
Detail |
| ID |
Enter the ID of the view to download. |
Outputs
| Output |
Output Type |
| Pivot view content |
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 dataset from a Wdata table to a new or existing spreadsheet, use an Export File to Spreadsheet command.
Properties
| Property |
Detail |
| File ID |
Enter the ID of the table dataset 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. |
| Revision |
Enter the version of the sheet to retrieve data from. For the current version, enter -1. |
Outputs
| Output |
Output Type |
| Row count |
Integer |
| Data |
File |
Exit dodes
| 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, add a map of their names and values.
Note: Enter the values of any multi-select parameters in Multi-select params.
|
| Run asynchronously |
To run the query asynchronously, and not wait until the query finishes to complete the command, check this box. |
| Multi-select params |
If the query has multi-select parameters defined, add the name and values of each. |
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 fact—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 |