Flat File import with header and detail: file parse to select one detail row?

Integrator.io
, ,
1

I'm working with a rather unwiedly flat file provided by a vendor (I don't have control over the layout of the flat file).

The file has both header rows and detail rows. I need to extract values from the header, and from any one of the detail rows.

Basic row format: the "R" or "S" prefix indicates header or detail rows, respectively. The MM/DD/YYYY indicates a date. Each group has the same date.

R0000000001Customer Name One
S0000000001Detail Row 1  11/08/2023
S0000000001Detail Row 2  11/08/2023
...
S0000000001Detail Row n  11/08/2023
R0000000002Customer Name Two
S0000000002Detail Row 1 11/20/2023
S0000000002Detail Row 2 11/20/2023
...
S0000000002Detail Row n 11/20/2023

I have a file parser configuration that is pulling out the header fields correctly, and then an array of details[*]. I can preview the dates as expected.

I only really need the numeric ID, and then any one of the RowDate values--all the RowDates per customer are the same. For import, I want to map the ID, Customer, and RowDate, just one instance, regardless of how many detail rows there are.

I need to import just:

R0000000001,Customer Name One,11/08/2023
R0000000002,Customer Name Two,11/20/2023

When I map the fields for import, the preview shows everything correct.

When I actually run the import, the details[*].RowDate mapping is ignored. It doesn't even appear in the logs in NetSuite, as if it's getting dropped during parsing. Only the header bits survive the import.

I've tried flipping between one-to-many settings and other fiddling, but still get empty results on the date fields.

Is there some handlebar magic I need to apply to extract or summarize the date field? Or is this just a bug?

2

@troythompson446 you should just be able to map details[0].RowDate where 0 indicates using the first position of the array.

Also, out of curiosity, can you share some screenshots of your export definition to parse this?

3

Using the index [0] instead of [*] seems to work, despite the preview feature not quite showing that it's a legitimate solution. Thanks for the tip!