Missing Interchange Control Number

Integrator.io
, , ,
1

My fellow Celigoans!

I have a support ticket in for this, but I wanted to attempt to get more eyes on what's going on.

In the preview for my flow, I have an Interchange Control Number.

The image shows a code editor on the left with file definition rules and sample flow data on the right, highlighting the synchronization of an "Interchange Control Number." (Captioned by AI)
The image shows a code editor on the left with file definition rules and sample flow data on the right, highlighting the synchronization of an "Interchange Control Number." (Captioned by AI)1766×462 93.2 KB

However, the file that gets sent, the Interchange Control Number, comes through as nothing but zeros.

image

I've tried:

  • Changing the Occurrences on the ISA segment
  • Changing the Type from Number to String
  • Using the Celigo-generated control number
  • Using the Interchange Control Number(IEA02) since they should be the same value anyway

Regardless of what I do, it continues to export zeros instead of an ICN. Do you have any thoughts on where I'm going wrong?

2

Can you check that the field "Interchange Control Number" is correctly set in the json you are passing to the import?
The Sample data Celigo shows in the top right for EDI parsers isn't the actual mock-data it is receiving from any previous steps, it's a separate example that is stored on the import.

3

I've done that as best as I'm aware of, and I keep getting the same result. I'm just confused as to where it's getting the zeros from. If it's not passing the data from the flow, then it should be a blank string.

4

This is just a theory, but the EDI Generator V2 / EDI Profile feature sources the X12 header data from the EDI Profile. The profile also contains the next value of the ICN. It could be that when the generator is creating the ISA envelope the document itself isn't loaded yet, just the edi profile, and thats why the handlebar doesn't work. Then the generator pads the ICN with zeros to make it the mandatory 9 chars long.

Edit: could you try if {{0.[Interchange Control Number]}} works? Just a wild thought.

5

+1 for the term "Celigoans" :rofl: