{"hierarchies":[{"id":265,"coreOrgId":null,"parentId":78,"isFolder":false,"definitionId":"c7939965fbee4434bdabf14a15692ffa","displayName":"Example CSV File Upload","version":1,"isPublished":true,"createdAt":"2025-05-22T16:30:13+00:00","lastExecutedAt":null,"avgRuntime":null,"latestInstanceStatus":null,"protected":false,"cronSetting":null,"endpointPath":"/example/fileupload","inMaintenanceWindow":false,"securedEndpoint":"red","createdBy":"c9542f24-5bb7-49bc-9f47-01c8a3784769","updatedBy":"c9542f24-5bb7-49bc-9f47-01c8a3784769"}],"flowz":[{"definitionId":"c7939965fbee4434bdabf14a15692ffa","versionId":"74d0cc911eb7423a9c9602fad5eb6bec","tenantId":null,"name":"Example CSV File Upload","displayName":"Example CSV File Upload","description":"Imports .csv file into Test.Example table","channel":null,"version":1,"variables":{"data":{}},"customAttributes":{"data":{}},"contextOptions":null,"isSingleton":false,"persistenceBehavior":"WorkflowBurst","deleteCompletedInstances":false,"isPublished":true,"isLatest":true,"tag":null,"activities":[{"activityId":"eb088e86-5de7-4a4d-9fdf-5263db06f243","type":"HttpEndpoint","name":"FileUpload","displayName":"HTTP Endpoint","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Path","syntax":null,"expressions":{"Literal":"/example/fileupload"}},{"name":"Methods","syntax":null,"expressions":{"Json":"[\"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":"f42e0591-2217-4954-9315-cf1e0ad1feb3","type":"SetVariable","name":null,"displayName":"Set Variable: Base64String","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"VariableName","syntax":null,"expressions":{"Literal":"Base64String"}},{"name":"Value","syntax":"JavaScript","expressions":{"JavaScript":"\"\""}}],"propertyStorageProviders":{}},{"activityId":"df29bf79-1f2e-433e-8782-9d58a6e03fa6","type":"Redis","name":"FileDetails","displayName":"REDIS Cache","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Method","syntax":null,"expressions":{}},{"name":"Variable","syntax":"JavaScript","expressions":{"JavaScript":"\"FineUploader[\" + activities.File.Output().Uuid + \"]\""}},{"name":"DataToAssign","syntax":null,"expressions":{}},{"name":"WorkflowOnly","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"49bebe7c-4143-4203-a492-816665d1606e","type":"SetVariable","name":null,"displayName":"Set Variable: Base64String","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"VariableName","syntax":null,"expressions":{"Literal":"Base64String"}},{"name":"Value","syntax":"JavaScript","expressions":{"JavaScript":"activities.FileDetails.RedisValueString() != \"\" ? JSON.parse(activities.FileDetails.RedisValueString()).Base64String : \"\""}}],"propertyStorageProviders":{}},{"activityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","type":"ForEach","name":"File","displayName":"For Each: File","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Items","syntax":"JavaScript","expressions":{"JavaScript":"JSON.parse(activities.FileUpload.Output().Body.file)"}}],"propertyStorageProviders":{}},{"activityId":"2b8619ec-14ac-4a3a-ab72-bf90a693eb76","type":"CsvDataSource","name":"CSVParser","displayName":"CSV file parser","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Separator","syntax":null,"expressions":{}},{"name":"CollectionName","syntax":null,"expressions":{"Literal":"Records"}},{"name":"CsvBodyBase64Encoded","syntax":"JavaScript","expressions":{"JavaScript":"Base64String"}}],"propertyStorageProviders":{}},{"activityId":"1da042b3-4627-4bc1-8c17-f1c42b767eb1","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":"71ec0487-9a28-4ff0-9b06-8a69f0e95b3f","type":"RunJavaScript","name":null,"displayName":"Run JavaScript","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Script","syntax":"Literal","expressions":{"Literal":"setVariable(\"RecordsJson\",activities.CSVParser.RecordsJson());"}},{"name":"PossibleOutcomes","syntax":null,"expressions":{}}],"propertyStorageProviders":{}},{"activityId":"cf36a112-4c16-437b-b4d7-dc8cd16d6e12","type":"If","name":null,"displayName":"If/Else","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"Condition","syntax":"JavaScript","expressions":{"JavaScript":"Base64String != \"\""}}],"propertyStorageProviders":{}},{"activityId":"fdfc6d13-3700-4d77-aa82-13f57ebd730e","type":"SetVariable","name":null,"displayName":"RedisValueString","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"VariableName","syntax":null,"expressions":{"Literal":"RedisValueString"}},{"name":"Value","syntax":"JavaScript","expressions":{"JavaScript":"activities.FileDetails.RedisValueString()"}}],"propertyStorageProviders":{}},{"activityId":"5df03adb-f5cd-4536-b776-ff06d4809539","type":"ExecuteSqlAgainstCloudToolz","name":null,"displayName":"ZenQL Statements","description":null,"x":null,"y":null,"persistWorkflow":false,"loadWorkflowContext":false,"saveWorkflowContext":false,"properties":[{"name":"ExpectedResults","syntax":null,"expressions":{"Literal":"No records"}},{"name":"Script","syntax":"Literal","expressions":{"Literal":"TRUNCATE TABLE [Test].[Example];\n\nINSERT INTO [Test].[Example]\n([Field1],\n[Field2],\n[Field3])\nSELECT\n    [Field1] ,\n    [Field2] ,\n    [Field3]\n  FROM OPENJSON(@json)\n  WITH (\n  [Field1] nvarchar(255),\n  [Field2] nvarchar(255),\n  [Field3] nvarchar(255)\n  )"}},{"name":"Parameters","syntax":null,"expressions":{"JavaScript":"JSON.stringify([{Name:\"@json\",Value:activities.CSVParser.RecordsJson()}])"}},{"name":"Timeout","syntax":null,"expressions":{}}],"propertyStorageProviders":{}}],"connections":[{"sourceActivityId":"f42e0591-2217-4954-9315-cf1e0ad1feb3","targetActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","outcome":"Done"},{"sourceActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","targetActivityId":"df29bf79-1f2e-433e-8782-9d58a6e03fa6","outcome":"Iterate"},{"sourceActivityId":"eb088e86-5de7-4a4d-9fdf-5263db06f243","targetActivityId":"f42e0591-2217-4954-9315-cf1e0ad1feb3","outcome":"Done"},{"sourceActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","targetActivityId":"1da042b3-4627-4bc1-8c17-f1c42b767eb1","outcome":"Done"},{"sourceActivityId":"49bebe7c-4143-4203-a492-816665d1606e","targetActivityId":"cf36a112-4c16-437b-b4d7-dc8cd16d6e12","outcome":"Done"},{"sourceActivityId":"cf36a112-4c16-437b-b4d7-dc8cd16d6e12","targetActivityId":"2b8619ec-14ac-4a3a-ab72-bf90a693eb76","outcome":"True"},{"sourceActivityId":"df29bf79-1f2e-433e-8782-9d58a6e03fa6","targetActivityId":"fdfc6d13-3700-4d77-aa82-13f57ebd730e","outcome":"Done"},{"sourceActivityId":"fdfc6d13-3700-4d77-aa82-13f57ebd730e","targetActivityId":"49bebe7c-4143-4203-a492-816665d1606e","outcome":"Done"},{"sourceActivityId":"cf36a112-4c16-437b-b4d7-dc8cd16d6e12","targetActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","outcome":"False"},{"sourceActivityId":"2b8619ec-14ac-4a3a-ab72-bf90a693eb76","targetActivityId":"71ec0487-9a28-4ff0-9b06-8a69f0e95b3f","outcome":"True"},{"sourceActivityId":"2b8619ec-14ac-4a3a-ab72-bf90a693eb76","targetActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","outcome":"False"},{"sourceActivityId":"71ec0487-9a28-4ff0-9b06-8a69f0e95b3f","targetActivityId":"5df03adb-f5cd-4536-b776-ff06d4809539","outcome":"Done"},{"sourceActivityId":"5df03adb-f5cd-4536-b776-ff06d4809539","targetActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","outcome":"Error"},{"sourceActivityId":"5df03adb-f5cd-4536-b776-ff06d4809539","targetActivityId":"3ac686d0-800f-46c8-935e-d1dc50f57eb0","outcome":"Done"}]}]}