Message that Contains a Work Order

Inbound messages are added to the integration database using Microsoft SQL Server 2016 version or higher.

Message that Contains a Work Order

INSERT INTO erp.erp_integration_inbound_messages (Message_Type, Media_Type, Message, Inserted_By)
                VALUES ('workOrder', 'application/json', '{WOID}', '<user name>')
            

where {WOID} is a JSON document that specifies the work order.