This discussion is archived
1 Reply Latest reply: Jul 12, 2013 8:22 AM by Ron M RSS

Save Nutrient Analysis Web Service

978454 Newbie
Currently Being Moderated

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 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points