Connector Improvement: Add UOM Code to Coupa Order Lines
In same cases is during the creation of an order line the uom_id not filled.
I can get the uom later with a call , but it's then a new field uom code.
"uom":{"code":"CMK","name":"m²"}
Please add the uom code as new column to the order line table.
-
Official comment
Hi David -
Thanks for submitting this request. You should be able to join the ORDER_LINE table to the UNIT_OF_MEASURE table via the `uom_id` on the ORDER_LINE. Does that logic not work for your specific use case?
Thanks,
Erin
-
It's not always filled.
Right now I use the API to get the uom code for each order line which has no uom_id.
IMHO should this be part of the Fivetran sync.
Please sign in to leave a comment.
Comments
2 comments