Can a MySQL Connector Lookup create a new node in XML?

Data Integration CData Arc
, ,
1

My lookup looks like this

076dfedc-a1d8-4078-9d26-d5ae871b6def.png
076dfedc-a1d8-4078-9d26-d5ae871b6def.png906×656 21.1 KB

`/Items/tracking_events/parcel` node does not exist. Only /Items/tracking_events exists

When I run the connector I don’t get a parcel or a barcode node.

I have also tried /Items/tracking_events/parcel_barcode.

Does the XML node have to exist in the incoming message?

I can extract the barcode to a message header okay.

2

You’re using an earlier version of the Lookup connector here - in the latest release of the Lookup connector from the 23.3 release of CData Arc at https://arc.cdata.com/support/builds/ you’ll find that the Lookup feature has been revamped, and you can declare a parent folder for the new elements to be added to:

bfb26125-6dfc-40c5-974b-cdef9c921bda.png
bfb26125-6dfc-40c5-974b-cdef9c921bda.png938×792 20.4 KB

This even has a test button that you can use to try it out:

5d86879b-9e6e-40c0-8e01-34452c5879ce.png
5d86879b-9e6e-40c0-8e01-34452c5879ce.png899×221 14.1 KB

The version that you’re on is a little simpler, just allowing you to output a sibling element, so /Items/tracking_events/parcel_barcode should have worked - what were you seeing when you did that?

3

Okay, I think I have more info on 23.0.8517.0

  • Using a destination of /Items/parcel_barcode works. A new node is created
  • /Items/thing/parcel_barcode did not create a new node ‘thing’ or subnode parcel_barcode. thing doesn’t exist in the original XML.
  • /Items/tracking_events/parcel_barcode gives a ‘Success’ result but the parcel_barcode node is not added to the existing /Items/tracking_events.

In the meantime we  will upgrade to the latest version