Concatenating JSON Strings in a pulldata() Request

Dylan_Wingler

I'm trying to concatenate several attributes out of a JSON string in a pulldata() request. I've written a script to pull in data as a JSON string from another feature layer based on a geopoint. What I need is to combine multiple attributes from that JSON string to create the full mailing address.

Below is my current survey. In the Mailing Address calculation is all of the fields needed for the full mailing address.

 

Below is an example of the current output.

The desire outcome for mailing address is:

PO Box 1129

New Bern, NC 28560

I've tried using pulldata("@json",${myjson}, concat("attributes.TMADDR", "attributes.CITYNM", "attributes.TAXSTE", "attributes.ZIP"))

as well as pulldata("@json",${myjson}, concat("attributes.TMADDR" + "attributes.CITYNM" + "attributes.TAXSTE" + "attributes.ZIP"))

 

Does anyone have any ideas?

KimberlyMcCallum

Do you mean that you are struggling to get all of the required address information into a correctly formatted address (as shown) to display to the user in a note field or something? It looks like from your screenshot, that some of your info may be incorrect (e.g., "attributes.PANAME" should be the owner according to your survey but it is returning the value "NEW BERN-CITY OF". Is that correct?). I'm probably missing something! 

In the past, I've done similar stuff by just writing another JavaScript function to handle and format that the output. Maybe something like the snippet below and then pass your attributes in another pulldata JS call? 

 

 

 

function formatAddress(address, city, state, zip){
  return `${address}<br>${city}, ${state} ${zip}`;
}