Box: Delete Shared Link of File
Deletes a Shared Link URL for the specified file on Box. An error will occur if there is no shared link
Questetra BPMS: Process, Batch Extract by Filter as TSV
Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.
SendGrid: Global Unsubscribes, Add Emails
Adds Email addresses to the SendGrid Global Unsubscribe list.
SendGrid: Group Unsubscribes, Add Emails
Adds Email addresses to the SendGrid Group Unsubscribe list.
SendGrid: Recipient, Add or Update
Adds a destination to the SendGrid contact. If a destination with the same email address has already been registered, the value of the reserved and custom fields will be updated.
TSV String, Create Cross Table of Count
Aggregates the count of data by 2 aggregation-key columns: Pivot table. Count and Percentage are tabulated as a cross table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. 2D frequency distribution.
TSV String, Create Summary Table of Count
Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. Frequency distribution.
TSV String, Switch Rows and Columns
Switches the row and column indices of the rectangle TSV. The output matrix (Transposed Matrix) is obtained by changing cell(x,y) to (y,x). Used for data arrangement for frequency distribution tables and histograms.
Downloading Process and Task Lists Using Workflow API (criteria)
As discussed previously in the article regarding reportId, there is another method that can be used to download Process and Task data which utilizes criteria XML.
Google Sheets: Append New Row
Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if necessary.
TSV String, Create Cross Table for Numeric Column
Aggregates the values in a numeric column by 2 aggregation-key columns: Pivot table. Sum, Percentage, Count and Average are tabulated as a cross table TSV. Eg, “Sales for each combination of Client-Y and Store-X” is aggregated from “Sales log TSV”.
TSV String, Create Summary Table for Numeric Column
Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table TSV. For example, “Sales for each client” is aggregated from “Sales log TSV”. Grand Total Tabulation.
TSV String, Verify Rectangle
Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible to get the number of rows and columns after formatting. No trailing newline will be added to the verified TSV.
kintone: Delete Record
Deletes records in a Kintone App. You can delete multiple records at once. When you delete multiple ones you should write one record ID per line.