Hey folks I've got a json object returning enormously long names for fields that deserialize fine but when I ask structKeyExists(jsonobj,'superlongfieldnamewithwaytomuchinformation'). What is the limit on the key name and anyone find a work around (this one is 46 characters long).

Does it error when you "ask"? What's the error say?

key doesn't exist

Does it show when you dump the object?

Element WHATTYPEOFPROFESSIONALSERVICESDOYOUPROVIDE___C is undefined in a CFML structure referenced as part of an expression.

^^what's

roW_NUMBERundefinedwhattypeofprofessionalservicesdoyouprovide___cstructaccessLevel20

?

sorry

How are you providing the key to

structKeyExists()

? Seems like it could be a typo.

the fetch is based on an argument

What exactly are you dumping in the screenshot? In the screenshot and your original question, it seems that

whattypeofprofessionalservicesdoyouprovide___c

is in the top-most level (directly inside whatever you dumped:

structKeyExists(jsonobj,'superlongfieldnamewithwaytomuchinformation')

), but your subsequent code snippets,

structKeyExists(jsonObj.columnMetadata,'#arguments.customField#')

, indicate a lower level,

jsonObj.columnMetadata

.

I'm dumping columnMetadata

I'm not aware of any struct key length restrictions

because the issue is likely the key and the other information is irrelevant and distraction

yeah - they key length seems to be fine https://trycf.com/gist/b6c15b35252fdabbdd585d50223dad0d/acf2021?theme=monokai

????

is

arguments.customField

exactly the same as the key in the struct? I'm still learning toward typo or checking the wrong struct level

yes

I'm assuming you dumped out

jsonObj.columnMetadata

in your screenshot?

<cffunction name="getCustomFieldMetaData">

<cfargument name="customField" type="string" required="true"> <cfoutput> <cfsavecontent variable="variables.jsonbody"> { "msql": "select #arguments.customField# from Individual where (#arguments.customField# <> '')", "page": 0, "pageSize": 1 } </cfsavecontent> </cfoutput> <!--- <cfdump var="#variables.jsonBody#"><cfabort> ---> <cfhttp url="#BaseUrl#/search/executeSearch" method="post"> <cfhttpparam type="header" name="Content-Type" value="application/json"> <cfhttpparam type="header" name="authorization" value="#accessToken#"> <cfhttpparam type="body" value="#variables.jsonBody#" /> </cfhttp> <!--- <cfdump var="#cfhttp#"><cfabort> ---> <cfset jsonObj = deserializejson(cfhttp.filecontent)> <cfset customMeta = jsonObj.columnMetadata> <cfdump var="#customMeta#"> <cfif structKeyExists(jsonObj.columnMetadata,'#arguments.customField#')> extensionExists <cfelse> doesn't exist </cfif> <cfset retArray = arrayNew(1)> <!--- <cfdump var="#retStruct#"><cfabort> ---> <cfset arrPickList = jsonObj.columnMetadata['#arguments.customField#'].pickListEntries> <cfloop from="1" to="#arrayLen(arrPickList)#" index="i"> <cfset temp=arrayAppend(retArray,arrPickList[i].value)> </cfloop> <cfreturn retArray> </cffunction>

right - so is the

arguments.customField

value all lowercase?

It is not

OK - so in CFML the case of keys is not important, but if that 'struct' is actually a java map object then case does matter.

cf isnt' typically case-sensitive, though. At least not for

structKeyExists

worth a try anyway

thx all, misspelled