cancel
Showing results for 
Search instead for 
Did you mean: 

CPI message mapping quotes.

VG141
Explorer
0 Kudos

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"
      },

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Ryan-Crosby
Active Contributor

It's not supported... see screenshot - 

Screenshot 2024-05-14 at 09.05.21.png

 

Regards,

Ryan Crosby