Orchestrator Tasks API Helper

Bronze Certified

Custom Activity

0 reviews

485

Version: 1.0.0 (View History)

Overview Reviews Questions

Summary

Get Orchestrator action tasks item, filtered by their fields. Extract data table with Action Tasks fields and related Action TaskForm fields

Overview

This Custom Activity contains the following two activities:
GetTasks
ExtractTasksFormDataTable
With GetTasks you can get a Json object with all the tasks fulfilling the filters properties (listed below). 
If you set more than 1 filter property, the logic operator "and" will be applied automatically except for CustomFilters which has a special behaviour: it allows you to add a custom query part to the rest of the query so, if you are setting other properties as well you have to specify the logic operator, otherwise you don't have to. 
Examples:
If you want to extract all the tasks whose title is not "Report" you just have to set the CustomFilters property this way "not(Title eq 'Report')"
if you want to extract all the tasks with priority "High" and Catalog='Invoices' or Catalog='Receipts' you have to set: Priority='High', CustomFilters="and (TaskCatalogName eq'Invoices' or TaskCatalogName eq 'Receipts')"
CustomFilters: if set along with other properties, you need to specify the logic operator. For example: if Status is set to "Pending" and you want to add a custom filter, you have to set CustomFilter="<logic operator> <your custom filter>". If CustomFilter is the only filter, you just have to set CustomFilter="<your custom filter>" (without the logic operator). You can find more info about api requests filtering here.

With ExtractTasksFormDataTable you can extract Tasks fields and related TaskForm data fields. The activity properties are:
jsonObjFromTasksAPI: the Json object returned by GetTasks activity
TaskFieldsToExtract: an array of string, listing the Task fields to be extracted
TaskFormFieldsToExtract: an array of string, listing the TaskForm data fields to be extracted