1 Reply Latest reply: Jul 12, 2013 10:22 AM by Ron M-Oracle RSS

    Save Nutrient Analysis Web Service

    978454

      Hi,

       

      I'm trying to consume the Save Nutrient Analysis v3.0 web service of the EP 3.3. And I'm getting the following error:

       

      "RESULT_INVALID_INPUT UOM [ISOCode:GR, Abbreviation:g] not allowed for InfoodsCode:SUGAR"

       

      The complete input I'm giving for NutrienItems is:

       

        <v3:NutrientItems>

        <v3:tNutrientItem>

        <v3:InfoodsCode>SUGAR</v3:InfoodsCode>

        <v3:ValuePer100Gms>0.3298</v3:ValuePer100Gms>

        <v3:UOM>

        <v33:ISOCode>GR</v33:ISOCode>

        <v33:ID>G</v33:ID>

        <v33:Abbreviation>g</v33:Abbreviation>

        </v3:UOM>

        <v3:Source>From Manufacturer</v3:Source>

        <v3:Comments xsi:nil="true" />

        </v3:tNutrientItem>

        </v3:NutrientItems>

       

      I already tried entering different combinations of InfoodsCode and UOM, and still getting the same error message. This is the query I used to get all the possible combinations:

       

        SELECT

         UOM.ID

         ,UOMML.NAME

         ,UOMML.ABBREVIATION

         ,UOM.ISOCODE

         ,FCLNUTRIENT.INFOODSID

        FROM

         UOM

        INNER JOIN UOMML

         ON UOM.PKID = UOMML.FKUOM

         AND UOMML.LANGID = 0

        INNER JOIN FCLNUTRIENT

         ON UOM.PKID = FCLNUTRIENT.FKUOM

        

      I would appreciate your help.

       

       

      Thanks!

       

       

      -Victoria