XML Dynamic Tables and Datamap

OL Connect Professional
1

Hello All

I have an XML file, single record, and it has several dynamic tables. I am trying to add fields into the datamap showing a record count for each dynamic table as I wish to set some rules based on how many records in the table(s).

I have tried various things around JavaScript including xPath but can’t get the syntax correct.

Any ideas?

2

You can use the count() function through XPATH.

See attached Datamapper example.

arrayLengthExample.OL-datamapper (7.0 KB)

In it you’ll see that I added two fields in each Extraction preceding an array (loop).

Look at the XPATH.

count Function (XPath) | Microsoft Learn

1 Like
3

That is very helpful. I think I was close but no cigar. Many thanks.