2 weeks ago
All, Quantity and amount fields are defined as xs:decimal in my schema. After the xml to json conversion in iFlow, i notice that they are getting populated as "10" instead of 10. Any pointers on how to get rid of the quotes around the numbers? Here's the schema definition:
<xs:element name="SupplierIsSubcontractor" type="xs:boolean"/>
<xs:element name="PurchaseOrderQuantityUnit" type="xs:string"/>
<xs:element name="OrderPriceUnit" type="xs:string"/>
<xs:element name="NetPriceQuantity" type="xs:decimal"/>
<xs:element name="PurchaseOrderItemCategory" type="xs:string"/>
<xs:element name="AccountAssignmentCategory" type="xs:string"/>
<xs:element name="NetAmount" type="xs:decimal"/>
<xs:element name="GrossAmount" type="xs:decimal"/>
<xs:element name="OrderQuantity" type="xs:decimal"/>
<xs:element name="NetPriceAmount" type="xs:decimal"/>
<xs:element name="OrderPriceUnitToOrderUnitNmrtr" type="xs:decimal"/>
<xs:element name="OrdPriceUnitToOrderUnitDnmntr" type="xs:decimal"/
Below is the payload after xml to json conversion.
"_PurchaseOrderItem": [
{
"PurchaseOrderItem": "10",
"PurchaseOrderCategory": "F",
"DocumentCurrency": "USD",
"MaterialGroup": "E002",
"PurchaseOrderItemText": "From CPI",
"ProductTypeCode": "1",
"CompanyCode": "2024",
"Plant": "2024",
"PurchaseOrderQuantityUnit": "EA",
"OrderPriceUnit": "EA",
"NetPriceQuantity": "1",
"PurchaseOrderItemCategory": "0",
"AccountAssignmentCategory": "P",
"NetAmount": "10",
"GrossAmount": "10",
"OrderQuantity": "10",
"NetPriceAmount": "1",
"_PurchaseOrderScheduleLineTP": {
"ScheduleLineDeliveryDate": "2024-05-14",
"SchedLineStscDeliveryDate": "2024-05-14",
"ScheduleLineOrderQuantity": "10",
"PurchaseOrderQuantityUnit": "EA",
"Currency": "USD"
},
It's not supported... see screenshot -
Regards,
Ryan Crosby
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.