Field not populating: Using pulldata from hosted table

[dsinha]

Hello everyone,

I am trying to pull owner information from a hosted table (PropertyOwnerDetails) using the Parcel number (parcel_number in Parcels_Carlisle, map in PropertyOwnerDetails, both fields are String) as the common link. I have tried different solutions but just cannot get it to work. I do not get any error message - the field just remains blank.    

Any help would be appreciated.

Thanks!

[Neal_t_k]

Try to do a helper field with your where clause outside of your pulldata calculation

whcl:    concat("map = ",${parcel_number})

and then put  ...FeatureServer/0", ${whcl})

Calculations in side pulldata functions sometime cause issues

[dsinha]

@Neal_t_k thanks for your help.

I tried your suggestion but it did not work:

Again, no error message.

[TylerGraham2 · Accepted solution]

Is the parcel number field actually a number field type (like an integer)? Our parcel numbers are stored as text. If it is a text field you need to enclose your parcel number in quotes.  So your query builder field should look like:

concat("map='",${parcel_number},"'")

[dsinha]

@TylerGraham2 you are absolutely right. That was indeed the solution that was offered by Esri tech support.

Additionally, we also realized that the table I was trying to pull the records from had around 700+ values in the join field (parcel number) that was formatted differently (and extra "-"). I was sitting inside one of those parcels whose ID was formatted incorrectly while I tested the app. So no records were returned during my tests. 🙄

Thank you all!

[Neal_t_k]

Just to rule it out, did you check that the rest url allow queries? and did you directly query the url to see if it works as expected?

[dsinha]

Hello @Neal_t_k yes the REST url allows query.

And I was able to query the layer directly using steps shown here, and it worked without any problem.