I have an issue in AI Builder Purchase Order Line Item Extraction.
Header Information fetched perfectly.
Line Item if PO have only one line item one of the column value not appearing and is emplty i am attaching the po as well , kindly check and advise. Thanks.
[
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"QTY_0020fe59d9251111a7843d30c08b2cc9bd98": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"value": "", // value is 0 but no issues if string is empty considered it to be 0
"displayName": "QTY Received Cases",
"fieldType": "string",
"text": "" // value is 0 but no issues if string is empty considered it to be 0
},
"QTY_002035e3d1eb711e11e0ea46af1c27e21e8c": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"value": 145, //It is correct
"displayName": "QTY Ordered Case",
"fieldType": "number",
"text": "145.00", //It is correct
"location": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"pageNumber": 1,
"boundingBox": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"left": 0.6323486170495882,
"top": 0.35514018691588783,
"width": 0.026676046116890118,
"height": 0.009719634724554616,
"polygon": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
"coordinates": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.6323486170495882,
"y": 0.35514018691588783
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.6590246631664783,
"y": 0.35514018691588783
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.6590246631664783,
"y": 0.36485982164044245
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.6323486170495882,
"y": 0.36485982164044245
}
]
}
}
}
},
"SKU_0020abdf87aa61b5f0696697e06193cc8cda": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"value": "2395845", // it is correct
"displayName": "SKU No.",
"fieldType": "string",
"text": "2395845", // it is correct
"location": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"pageNumber": 1,
"boundingBox": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"left": 0.028454418299638837,
"top": 0.35514018691588783,
"width": 0.035059907991644365,
"height": 0.009719634724554616,
"polygon": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
"coordinates": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.028454418299638837,
"y": 0.35514018691588783
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.0635143262912832,
"y": 0.35514018691588783
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.0635143262912832,
"y": 0.36485982164044245
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.028454418299638837,
"y": 0.36485982164044245
}
]
}
}
}
},
"QTY_00208accf0ccd3cc34b19d0b84498cb4f365": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"value": "", // value is 0 but no issues if string is empty considered it to be 0
"displayName": "QTY Received Pcs",
"fieldType": "string", // value is 0 but no issues if string is empty considered it to be 0
"text": ""
},
"QTY_00200b3550a250460c6289f73da150ae8ab6": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"value": "", //value must be 580 but here it is showing empty "here is the issue"
"displayName": "QTY Ordered Pcs",
"fieldType": "string",
"text": "" //value must be 580 but here it is showing empty "here is the issue"
}
}
]
2
Share
Report
All responses (
Answers (
