How to get shipment_Gid in ShipmentStatus message using integration saved query
Summary:
Hello All, is there a way to get shipment_gid based on shipment reference number in shipment status message.
xml attached
Integration Saved Query
SELECT SHIPMENT_GID FROM SHIPMENT_REFNUM WHERE SHIPMENT_REFNUM_QUAL_GID='domain_name.REF_Qualifier' AND SHIPMENT_REFNUM_VALUE like {%REFERENCE_NUMBER%}
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
0