{"hierarchies":[{"id":226,"coreOrgId":null,"parentId":209,"isFolder":false,"definitionId":"772475a8e3b9487db551793a41fbe655","displayName":"Best Practices: Tabulator","version":27,"isPublished":true,"createdAt":"2025-07-03T00:28:26+00:00","lastExecutedAt":"2025-07-03T00:54:43+00:00","avgRuntime":0,"latestInstanceStatus":"Finished","protected":false,"cronSetting":null,"endpointPath":"/BestPractices/Tabulator","inMaintenanceWindow":false,"securedEndpoint":"green","createdBy":"ad1f25c0-1eba-476c-9ec6-5c1c6928fa76","updatedBy":"ad1f25c0-1eba-476c-9ec6-5c1c6928fa76"}],"flowz":[{"definitionId":"772475a8e3b9487db551793a41fbe655","versionId":"2012de5a2a2346ff9b5cafe7e0f3c8ec","tenantId":null,"name":"Best Practices: Tabulator","displayName":"Best Practices: Tabulator","description":"This workflow demonstrates best practices for inserting a table onto a form.\n\nFor more info, visit:\nhttps://tabulator.info/","channel":null,"version":27,"variables":{"data":{}},"customAttributes":{"data":{}},"contextOptions":null,"isSingleton":false,"persistenceBehavior":"WorkflowBurst","deleteCompletedInstances":false,"isPublished":true,"isLatest":true,"tag":null,"activities":[{"activityId":"a591c34e-b774-4755-bdc9-3d61d87e7adc","type":"HttpEndpoint","name":"Endpoint","displayName":"HTTP Endpoint","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Path","syntax":null,"expressions":{"Literal":"/BestPractices/Tabulator"}},{"name":"Methods","syntax":null,"expressions":{"Json":"[\"GET\",\"POST\"]"}},{"name":"ReadContent","syntax":null,"expressions":{"Literal":"true"}},{"name":"TargetType","syntax":null,"expressions":{}},{"name":"Schema","syntax":"Literal","expressions":{"Literal":""}},{"name":"Authorize","syntax":null,"expressions":{}},{"name":"Policy","syntax":null,"expressions":{}},{"name":"AuthorizeWithCustomHeader","syntax":null,"expressions":{}},{"name":"CustomHeaderName","syntax":null,"expressions":{}},{"name":"CustomHeaderValue","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"ca7aeb34-bdd4-434d-88e7-ac4066bf323a","type":"RequestAuthorization","name":null,"displayName":"Request Authorization","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Role","syntax":null,"expressions":{}},{"name":"HttpRequest","syntax":"JavaScript","expressions":{"JavaScript":"activities.Endpoint.Output();"}}],"propertyStorageProviders":{}},{"activityId":"52d161bd-a9ed-44d6-afab-e5b32823b028","type":"WriteHttpResponse","name":null,"displayName":"Unauthorized HTTP Response","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Content","syntax":null,"expressions":{}},{"name":"ContentType","syntax":null,"expressions":{"Literal":"text/plain"}},{"name":"StatusCode","syntax":null,"expressions":{"Literal":"Unauthorized"}},{"name":"CharSet","syntax":null,"expressions":{"Literal":"utf-8"}},{"name":"ResponseHeaders","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"20da4e7d-8280-4dfc-a5da-f04009f66790","type":"Finish","name":null,"displayName":"Finish","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"ActivityOutput","syntax":null,"expressions":{}},{"name":"OutcomeNames","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"b9ad64fd-d40d-4165-a9e0-4d7ec489434d","type":"IntelligentQueryArchitectData","name":"PetResults","displayName":"PetResults IQA","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"IqaPath","syntax":null,"expressions":{"Literal":"$/ZENTSO/Best Practices/Best Practices: Pets Data"}},{"name":"Parameters","syntax":null,"expressions":{}},{"name":"Offset","syntax":null,"expressions":{}},{"name":"Limit","syntax":null,"expressions":{}},{"name":"CollectionName","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"bed6082b-9833-42f8-a7e1-feb3bc852b27","type":"WriteHttpResponse","name":null,"displayName":"Success HTTP Response","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Content","syntax":"JavaScript","expressions":{"JavaScript":"let tableDataNotes = activities.PetResults.ResultSet();\r\n\r\nvar tableSettingsNotes = {\r\n  maxHeight: \"600px\",\r\n  layout: \"fitColumns\",\r\n  selectableRows: true,\r\n  data: tableDataNotes, //set initial table data\r\n  pagination: true, //enable pagination\r\n  paginationSize: 10, //optional parameter to request a certain number of rows per page\r\n  paginationInitialPage: 1, //optional parameter to set the initial page to load\r\n  columns: [\r\n    {title:\"Selected\", formatter:\"rowSelection\", width:100, headerSort:false, resizable: false, frozen:true, headerHozAlign:\"center\", hozAlign:\"center\"},\r\n    {\r\n      title: \"User ID\",\r\n      field: \"OwnerID\",\r\n      sorter: \"string\",\r\n    },\r\n    {\r\n      title: \"Owner's Name\",\r\n      field: \"OwnerName\",\r\n      sorter: \"string\",\r\n    },\r\n    {\r\n      title: \"Pet's Name\",\r\n      field: \"PetName\",\r\n      sorter: \"string\",\r\n    },\r\n    {\r\n      title: \"Pet's Species\",\r\n      field: \"PetSpecies\",\r\n      sorter: \"string\",\r\n    },\r\n    {\r\n      title: \"Pet's Age (Years)\",\r\n      field: \"PetAge\",\r\n      sorter: \"number\",\r\n      formatter: \"money\",\r\n      formatterParams: {\r\n        symbol: \"\",\r\n      }\r\n    },\r\n  ],\r\n  // initialSort: [\r\n  //   { column: \"OwnerID\", dir: \"desc\" }, //sort by OwnerID\r\n  // ],\r\n};\r\n\r\nvar returnTable = {\r\n  TabulatorSettingsNotes: JSON.stringify(tableSettingsNotes),\r\n};\r\n\r\nreturn returnTable;"}},{"name":"ContentType","syntax":null,"expressions":{"Literal":"application/json"}},{"name":"StatusCode","syntax":null,"expressions":{"Literal":"OK"}},{"name":"CharSet","syntax":null,"expressions":{"Literal":"utf-8"}},{"name":"ResponseHeaders","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"abf6ade9-4ea6-4a2b-9d20-6d81b64e8ca1","type":"Fault","name":null,"displayName":"Fault","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Message","syntax":null,"expressions":{}}],"propertyStorageProviders":{}}],"connections":[{"sourceActivityId":"a591c34e-b774-4755-bdc9-3d61d87e7adc","targetActivityId":"ca7aeb34-bdd4-434d-88e7-ac4066bf323a","outcome":"Done"},{"sourceActivityId":"ca7aeb34-bdd4-434d-88e7-ac4066bf323a","targetActivityId":"52d161bd-a9ed-44d6-afab-e5b32823b028","outcome":"False"},{"sourceActivityId":"52d161bd-a9ed-44d6-afab-e5b32823b028","targetActivityId":"20da4e7d-8280-4dfc-a5da-f04009f66790","outcome":"Done"},{"sourceActivityId":"ca7aeb34-bdd4-434d-88e7-ac4066bf323a","targetActivityId":"b9ad64fd-d40d-4165-a9e0-4d7ec489434d","outcome":"True"},{"sourceActivityId":"bed6082b-9833-42f8-a7e1-feb3bc852b27","targetActivityId":"20da4e7d-8280-4dfc-a5da-f04009f66790","outcome":"Done"},{"sourceActivityId":"b9ad64fd-d40d-4165-a9e0-4d7ec489434d","targetActivityId":"abf6ade9-4ea6-4a2b-9d20-6d81b64e8ca1","outcome":"False"},{"sourceActivityId":"b9ad64fd-d40d-4165-a9e0-4d7ec489434d","targetActivityId":"bed6082b-9833-42f8-a7e1-feb3bc852b27","outcome":"True"}]}]}