Hello all, I have a flat file coming from my WMS that needs to be converted into an X12 E.D.I. file. The flat file doesn't contain the information needed for an ISA/GS segment so I'm attempting to build one. I know that much of the information can be hardcoded, but I wanted an outside opinion on wh…

@jackharris random numbers will typically work unless the destination you are sending this to does validation on what numbers have previously been sent. If you need to increment each time, you would need to store the counter somewhere else. Here is an example of using our state api to store a counte…

How would I call that within the flow though?

How would you make a random number handlebar? When I try the following I get letters: Expression: {{random "number" 9}} Result: 0e85c472d

@jackharris for now, the "number" option in the random handlebar expression is only available for NetSuite exports/imports. Here is another way to come up with the same thing: {{substring (regexReplace (join "" (join "" (random "crypto" 32) (random "crypto" 32)) (random "crypto" 32)) "" "[^0-9]" "g…

@jackharris if you need to use the state api, here is an example of how I would use it via a preMap script. Notice that the output is the same data coming in, but it adds a new cache object. Within that, it has the stored control numbers for you to reference in your file definitions. Each time this …

@kithunter I think you asked about the same thing on office hours today. You could utilize the above.

@tylerlamparter feel free to delete this comment due to clutter, but I did want to make sure to thank you profusely for this. Script looks amazing!

@tylerlamparter - Could this be modified to start recounting per flow run. For example, if I have one flow run then it appropriately increment for that flow run, but if a new flow is kicked off it would reset?

Creating ISA and GSA segments

Integrator.io

tylerlamparter (Tyler Lamparter) November 4, 2024, 9:53pm 10

@daveguderian yes see comment here: https://connective.celigo.com/t/indexing-and-incrementing-an-identifer/1008

Topic		Replies	Views
Using Celigo’s State API as a Numeric Identity Provider for EDI Control Numbers Automation in Action	3	125	June 17, 2025
Generating 997 Integrator.io file-transfer , import , branching , x12	4	71	February 15, 2024
Indexing and Incrementing an Identifer Integrator.io xml , import , page-size , amazon-s3	5	119	November 4, 2024
Missing Interchange Control Number Integrator.io flow-builder , import , edi , x12	4	78	June 16, 2025
Creating HL Segments Integrator.io edi , x12	22	72	February 14, 2024

Creating ISA and GSA segments

Related topics