Payment Method / Iman column referencing from different levels of hierarchical dataset (2 replies)
Dan, to answer you question, there's no direct means to support this through a VBScript. You can use a function such as Concatenate, but this is a bit of a workaround.
However, when grabbing orders from Magento, the first payment for an order is embedded in the order header.
If you scroll to the very end of the field list, you will see a number of fields with the "payment_" prefix. These may just need to selecting/importing.
Thanks
Closed due to inactivity.
When referencing columns in the VBscript is it possible to reference a column from another level of the hierarchy?
For example in the order entity we have the level Order and Order payment
If I wanted to get the payment method name for instace and use it with a field in Order I would expect to reference it like this:
OrderPayment.%Paymentmethod