Samples of response or content of generated JSON files

Error log list

ERROR_ID,TYPE,RETURN_ERROR_CD,FORM_NAME,MESSAGE_TEXT,CREATION_DT,EVT_HEADER_ID,EVT_DETAIL_SEQ
15206,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:01 PM",0,0
15207,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:04 PM",0,0
15208,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:07 PM",0,0
15209,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:10 PM",0,0
15210,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:13 PM",0,0
15211,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:16 PM",0,0
15212,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/21/2023 12:19 PM",0,0
15213,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 384","02/21/2023 12:21 PM",5960,2
15214,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 387","02/21/2023 12:21 PM",5960,1
15215,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 389","02/21/2023 12:22 PM",5960,3
15216,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 384","02/21/2023 12:22 PM",5960,2
15217,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 387","02/21/2023 12:22 PM",5960,1
….

Error log list information

[{"ColumnName":"ERROR_ID","ColumnAlias":null,"ColumnType":"NUMERIC","ColumnLength":null,"ColumnNullable":"false","ColumnIsPk":null,"ColumnPrecision":"18","ColumnScale":"0","ValueMap":null},{"ColumnName":"TYPE","ColumnAlias":null,"ColumnType":"VARCHAR","ColumnLength":"20","ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null},{"ColumnName":"RETURN_ERROR_CD","ColumnAlias":null,"ColumnType":"VARCHAR","ColumnLength":"20","ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null},{"ColumnName":"FORM_NAME","ColumnAlias":null,"ColumnType":"VARCHAR","ColumnLength":"20","ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null},{"ColumnName":"MESSAGE_TEXT","ColumnAlias":null,"ColumnType":"VARCHAR","ColumnLength":"2000","ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null},{"ColumnName":"CREATION_DT","ColumnAlias":null,"ColumnType":"TIMESTAMP","ColumnLength":"23","ColumnNullable":"false","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null},{"ColumnName":"EVT_HEADER_ID","ColumnAlias":null,"ColumnType":"NUMERIC","ColumnLength":null,"ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":"20","ColumnScale":"0","ValueMap":null},{"ColumnName":"EVT_DETAIL_SEQ","ColumnAlias":null,"ColumnType":"NUMERIC","ColumnLength":null,"ColumnNullable":"true","ColumnIsPk":null,"ColumnPrecision":"6","ColumnScale":"0","ValueMap":null},{"ColumnName":"LAST_MODIFIED_DT","ColumnAlias":null,"ColumnType":"TIMESTAMP","ColumnLength":"23","ColumnNullable":"false","ColumnIsPk":null,"ColumnPrecision":null,"ColumnScale":null,"ValueMap":null}]

Error log list with filtered date

ERROR_ID,TYPE,RETURN_ERROR_CD,FORM_NAME,MESSAGE_TEXT,CREATION_DT,EVT_HEADER_ID,EVT_DETAIL_SEQ
15695,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/22/2023 12:01 AM",0,0
15696,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/22/2023 12:04 AM",0,0
15697,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/22/2023 12:07 AM",0,0
15698,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13442","02/22/2023 12:07 AM",5973,1
15699,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 10","02/22/2023 12:08 AM",5973,2
15700,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 11","02/22/2023 12:08 AM",5973,3
15701,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13237","02/22/2023 12:08 AM",5973,4
15702,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13186","02/22/2023 12:09 AM",5973,5
15703,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13424","02/22/2023 12:09 AM",5973,6
15704,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13442","02/22/2023 12:09 AM",5973,1
15705,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 10","02/22/2023 12:10 AM",5973,2
15706,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 11","02/22/2023 12:10 AM",5973,3
15707,HTTP-ERROR,,,"Item PCS001 cannot use auto purchase order when replenishing from a location","02/22/2023 12:10 AM",0,0
15708,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13237","02/22/2023 12:11 AM",5973,4
15709,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13186","02/22/2023 12:11 AM",5973,5
15710,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13424","02/22/2023 12:11 AM",5973,6
15711,HTTP-ERROR,,ParLocationCount,"Must enter unit cost for item 13442","02/22/2023 12:12 AM",5973,

Error log with Message Type and error message

MESSAGE_TEXT,TYPE
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Must enter unit cost for item 384",HTTP-ERROR
"Must enter unit cost for item 387",HTTP-ERROR
"Must enter unit cost for item 389",HTTP-ERROR
"Must enter unit cost for item 384",HTTP-ERROR
"Must enter unit cost for item 387",HTTP-ERROR
"Item PCS001 cannot use auto purchase order when replenishing from a location",HTTP-ERROR
"Must enter unit cost for item 389",HTTP-ERROR
"Must enter unit cost for item 384",HTTP-ERROR
"Must enter unit cost for item 387",HTTP-ERROR
"Must enter unit cost for item 389",HTTP-ERROR
"Must enter unit cost for item 384",HTTP-ERROR
"Must enter unit cost for item 387",HTTP-ERROR
"Must enter unit cost for item 389",HTTP-ERROR
…