JSON Number

[Anonymous]

Hi all,

I'm having trouble understanding why the parsing method is not working here. All the JSON data that begins with "00." are failing. Is there anything I can do about this?

Message says: "Unable to process template language expressions in action 'ChemicalCompositionOutput' inputs at line '1' and column '36545': 'The template language function 'json' parameter is not valid. The provided value '{"Aluminum-Max": 0, "Aluminum-Min": 0,"Antimony-Max": 0, "Antimony-Min": 0,"Bismuth-Max": 0, "Bismuth-Min": 0,"Boron-Max": 0, "Boron-Min": 0,"Carbon-Max": 1.05, "Carbon-Min": 0.95,"Chromium-Max": 5.50, "Chromium-Min": 4.75,"Cobalt-Max": 0, "Cobalt-Min": 0,"Copper-Max": 0, "Copper-Min": 0,"Iron-Max": 92.75, "Iron-Min": 89.99,"Lead-Max": 0, "Lead-Min": 0,"Magnesium-Max": 0, "Magnesium-Min": 0,"Manganese-Max": 1.00, "Manganese-Min": 0.40,"Molybdenum-Max": 1.40, "Molybdenum-Min": 0.90,"Nickel-Max": 0, "Nickel-Min": 0,"Niobium-Max": 0, "Niobium-Min": 0,"Nitrogen-Max": 0, "Nitrogen-Min": 0,"Phosphorus-Max": 0.03, "Phosphorus-Min": 0,"Selenium-Max": 0, "Selenium-Min": 0,"Silicon-Max": 0.50, "Silicon-Min": 0.10,"Sulfur-Max": 0.03, "Sulfur-Min": 0,"Tellurium-Max": 0, "Tellurium-Min": 0,"Tin-Max": 0, "Tin-Min": 0,"Titanium-Max": 0, "Titanium-Min": 0,"Tungsten-Max": 0, "Tungsten-Min": 0,"Vanadium-Max": 0.50, "Vanadium-Min": 00.15,"Zinc-Max": 0, "Zinc-Min": 0,"Zirconium-Max": 0, "Zirconium-Min": 0,"-Max": 0, "-Min": 0}' cannot be parsed: 'Input string '00.15' is not a valid number. Path 'Vanadium-Min', line 1, position 932.'. Please see https://aka.ms/logicexpressions#json for usage details.'."

[Pstork1]

00.15 would be a valid string, but its not a valid number.  The number would need to be 0.15 not 00.15.  I would suggest doing a search and replace for '00.' in the JSON before trying to parse it.  

[Anonymous]

Thanks for reply! Is there anything I can change in the schema to make up for this? I thought it was being parsed as a string, not number the entire time.

[Pstork1]

It can't really be parsed as a string since its not in single quotes.  Its entered like a number, but its in an invalid format.  If you can't change the source to provide a valid format your only real choice is to modify the JSON text before trying to parse it.