The attribute is a represents a status code, so it should be interpreted as an integer, however the JSONTemplater always interprets it as a string, despite all my attempts at forcing it to integer.
Using @int(fme:get-attribute("_statuscode")) results in a TCL error (apparently the @int function is being evaluated before the fme:get-attribute function).
Also tried using an ExpressionEvaluator with @int(1.0) but this is still interpreted as a string.
Any ideas? Thanks!
Best answer by mark2atsafe
I got an answer to this directly from the developer.
Hope it's useful
Mark
---------------------------------------------
The short answer is: use an XQuery type cast, in this case xs:int, like so:
{
"status" : xs:int( fme:get-attribute("int_attr") )
}
The longer answer is this:
The fme:get-attribute function will return a value whose type corresponds to the underlying type of the FME attribute. In this case, the attribute is likely a string attribute. This can be checked by using a Logger transformer.
A 'cast' can be used to convert a string value to an integer. The syntax is quite simple, xs:int( "132" ). Strings can be converted to quite a few numeric types, but for JSON, the most useful casts will be:
strictly speaking, JSON is untyped, so a string representation is actually the correct way of transferring your numeric values.
Is there any particular reason for needing to transfer these otherwise?
David
-----
import fmeobjects def FeatureProcessor(feature):
attribName = "status" # Modify here value = feature.getAttribute(attribName) try: feature.setAttribute(attribName, int(value)) except: pass
-----
It will silently ignore all type errors.
David
+17
True JSON is text, you can always try the string formatter on your attribute.
I tried the StringFormatter before posting, it didn't make any difference in this scenario, FME still considers the result as a string :-)
David
+17
Hurry Python saves the day, but I do feel like we are treading water.....:)
FME really should have an AttributeTypeCoercer :-)
JSON actually has several data types including numbers, strings, booleans and nulls, and the JSONTemplater seems to automatically use the right type for attributes brought in from readers, it's just attributes created in the workspace that seem to always be interpreted as strings byt he JSONTemplater.
I wonder what is different about the PythonCaller vs. my ExpressionEvaluator attempt (other than that one is Python and the other is TCL).
+17Regards,
Itay
+43I got an answer to this directly from the developer.
Hope it's useful
Mark
---------------------------------------------
The short answer is: use an XQuery type cast, in this case xs:int, like so:
{
"status" : xs:int( fme:get-attribute("int_attr") )
}
The longer answer is this:
The fme:get-attribute function will return a value whose type corresponds to the underlying type of the FME attribute. In this case, the attribute is likely a string attribute. This can be checked by using a Logger transformer.
A 'cast' can be used to convert a string value to an integer. The syntax is quite simple, xs:int( "132" ). Strings can be converted to quite a few numeric types, but for JSON, the most useful casts will be:
+2I got an answer to this directly from the developer.
Hope it's useful
Mark
---------------------------------------------
The short answer is: use an XQuery type cast, in this case xs:int, like so:
{
"status" : xs:int( fme:get-attribute("int_attr") )
}
The longer answer is this:
The fme:get-attribute function will return a value whose type corresponds to the underlying type of the FME attribute. In this case, the attribute is likely a string attribute. This can be checked by using a Logger transformer.
A 'cast' can be used to convert a string value to an integer. The syntax is quite simple, xs:int( "132" ). Strings can be converted to quite a few numeric types, but for JSON, the most useful casts will be:
+19I got an answer to this directly from the developer.
Hope it's useful
Mark
---------------------------------------------
The short answer is: use an XQuery type cast, in this case xs:int, like so:
{
"status" : xs:int( fme:get-attribute("int_attr") )
}
The longer answer is this:
The fme:get-attribute function will return a value whose type corresponds to the underlying type of the FME attribute. In this case, the attribute is likely a string attribute. This can be checked by using a Logger transformer.
A 'cast' can be used to convert a string value to an integer. The syntax is quite simple, xs:int( "132" ). Strings can be converted to quite a few numeric types, but for JSON, the most useful casts will be:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
