Inbound Translation of a Transmission

[msk]

Hi,

We have a need to change the location id being sent in the Order Release transmission to OTM. In the transmission the external application is building a location id. But we want to ignore that id and lookup OTM for an id and use the id that is being looked up.

More info on the transaction: We are receiving the GlogXMLElement from the external system in GLOG schema format. We just want to replace the locationgid - /Transmission/TransmissionBody/GLogXMLElement/TransOrder/TransOrderLineDetail/TransOrderLine/ShipToLocationRef/LocationRef/Location/LocationGid/Gid/Xid with the one queried from OTM.


Any ideas on how we can achieve that.

Appreciate your time and suggestions.

Regards
SM

[cunninghamg]

Re: Inbound Translation of a Transmission

It would be very easy to have a workflow agent (triggered on Order - Created or Updated) to do this lookup and replace.

Gary

[msk]

Re: Inbound Translation of a Transmission

Hi,

Thanks for the quick reply. Would it be possible to handle this in the transmission layer itself before transaction is persisted in the tables.

Ideally we would not want to update system tables through our custom logic. If there is a way to replace the locationgid in the xml while processing the transmission, we would prefer that approach.

Believe, IntSavedQuery will help in doing it. We are exploring that option. Any alternate ideas are appreciated.

Thanks
SM

[jeff.depaul]

Re: Inbound Translation of a Transmission

MSK,
Which integration app are you using? We have done several "re-mappings" of data elements in the integration layer (i.e. before passed into OTM integration) for locations, items, organizations, and order release attributes.

-Jeff