Orchestration
...
Transform Data
Advanced Transformations (cloned)
4 min
need something more complex than basic transformations? want to write the code yourself? you can use advanced transformations to write complex jsonata expressions, which gives you significant flexibility to transform data according to your needs see jsonata docs https //docs jsonata org/overview\ html to assist you in writing expressions to access advanced mode, complete steps 1 4 on transform data docid\ k3rqhxxvfivjja27ryfty to open the transformation builder, then click switch to advanced on a block once you click switch to advanced , you cannot revert the block to a basic transformation a confirmation dialog displays switching "block 1" to advanced mode is irreversible existing transformations for this block will be converted are you sure you would like to continue? if you want to continue, click confirm when might you want to use advanced transformations? currently, the most common need for advanced data transformations transforming one object structure into a different structure for use within the playbook let's check out an example! transforming one object structure to a different structure use case avery wants to take data from a slack event and restructure the data to swimlane's common data model to do that, avery can use an advanced transformation block to write the jsonata expression first, avery creates a webhook trigger for ingesting slack events now, avery is ready to add the transform data action, switch to advanced mode, and define a new object with the attributes id, type, and timestamp, using playbook values to fill in the values for those attributes watch as avery creates the advanced transformation visit the jsonata exerciser https //try jsonata org/ to verify and/or practice writing jsonata expressions on the advanced mode block, click add playbook property to add a playbook property you cannot manually enter a playbook property