topic Re: AddRelatedFeature Url Parameter Error: Foreign key in ArcGIS Field Maps Questions

AddRelatedFeature Url Parameter Error: Foreign key

LuisaC — Wed, 02 Aug 2023 01:35:01 GMT

"Unable to Update Feature

The specified foreign key field couldn't be found."

I've been running into this error when attempting to add a related feature via url from a popup in my maps. The popup is on a polygon layer which is related to a point layer - both are in the same map, both layers are editable, and my foreign key field parameter is definitely the correct field name from the point layer.

I'm a little unsure of what might be causing this and I couldn't find much documentation surrounding the addRelatedFeature field maps parameter - anyone know what might be causing this error?

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Fri, 04 Aug 2023 21:19:33 GMT

Hi @LuisaC , what key fields are you using for your relationship? Is it a GlobalID -> GUID or are you using your own fields?

Have you tried using the key field from the "parent" layer? I understand this can be a little confusing but as the point of entry, and what you are editing in this scenario, is the related "child" feature it would then be the "parent" layer which is the foreignKeyField. Therefore if you are using GlobalID -> GUID relationship the foreignKeyField would be GlobalID. Give this a shot and let me know if you still get an error.

Re: AddRelatedFeature Url Parameter Error: Foreign key

LuisaC — Wed, 09 Aug 2023 15:17:52 GMT

That does appear to be the solution - thanks a ton!

Re: AddRelatedFeature Url Parameter Error: Foreign key

LWWCGIS — Mon, 06 Nov 2023 21:18:32 GMT

Could I see a good example of using this parameter? I am trying to create a related record using the addRelatedFeature but can't seem to get it working. I'm sure I'm missing one little thing. My URL looks like:

https://fieldmaps.arcgis.app?referenceContext=addRelatedFeature&itemID=9b009b91e54342ce84bb9af179f71fde&featureSourceURL=https://services1.arcgis.com/Txq2JUfAytfzQqPz/arcgis/rest/services/dev_WaterValves_InspectionView/FeatureServer/0&featureID={GlobalID}&foreignKeyField=GlobalID

EDIT: The only difference I see is that when I click this url inside of field maps it sends the GlobalID in uppercase whereas the link generated through webmapviewer the GlobalID is in lowercase. Using the link with lowercase GlobalID works. Why is field maps sending uppercase and is this what's causing issue?

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Tue, 07 Nov 2023 00:04:37 GMT

Hey @LWWCGIS , can you add some context about how you are using this URL? Is it from a popup in Field Maps and you are attempting to launch directly into a related record collection (perhaps in another map or layer)? Is the globalID parameter that is being "converted" the one in brackets or are you referring to the value for the foreignKeyField? I believe if its the one in brackets, ie pulling the globalID value from the table, then this would be a known issue.

Re: AddRelatedFeature Url Parameter Error: Foreign key

LWWCGIS — Tue, 07 Nov 2023 03:25:09 GMT

Hey @ColinLawrence,

Thank you for responding. I am using the URL inside fieldmaps to call an inspection through the popup to reduce the amount of clicks to get to the related table. You're correct in that the issue lies with the GlobalID in brackets. Fortunately, I have a workaround that seems to work by using arcade to strip off the brackets that are passed in the URL. Now I am getting a clean GlobalID. I should have thought of this before. 😊

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Tue, 07 Nov 2023 17:53:20 GMT

Thats great! We do see the need to be more consistent across the platform with how the GlobalID field is handled.

Re: AddRelatedFeature Url Parameter Error: Foreign key

RowanTolfts — Thu, 18 Jan 2024 14:57:36 GMT

Hi Colin, thanks for your help with this issue! I've got a feature layer with multiple related tables, and I've got the link working in that it opens the form for a new related record in one of the tables. Do you know if there's a way to specify in the URL parameters which table to add a record to?

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Thu, 18 Jan 2024 19:26:27 GMT

@RowanTolfts I believe it will default to the table that comes first in the service index given they share the same key field. Right now there is no way around that as far as i'm aware. I believe its something the team is investigating for the future.

Re: AddRelatedFeature Url Parameter Error: Foreign key

RowanTolfts — Fri, 19 Jan 2024 10:28:49 GMT

Hi Colin, that's a shame; glad to hear that it's being investigated by the team. Thank you for your help regardless!

Re: AddRelatedFeature Url Parameter Error: Foreign key

DanMakridakis — Tue, 26 Mar 2024 16:09:34 GMT

Thank you Dustin! Until I saw this I couldn't figure out why the URL wasn't working. I then had it return the URL as text in my pop-up and realized that field maps was adding the curly brackets to the globalid (while map viewer wasn't). A custom expression with a Replace function solved it!

Re: AddRelatedFeature Url Parameter Error: Foreign key

DanMakridakis — Tue, 26 Mar 2024 17:10:44 GMT

Colin, is there any way to push values into fields for the new related record via the URL? I know this can be done for URLs that launch Survey123 using Field:fieldname=value but this doesn't seem to have any impact when used with the related records in field map URL.

Solved!

Never mind, I found the solution in the documentation:
Field Maps - Deploy your map (Open your map from a link) - found under "Initiate updating a feature" section

Sample of the expression used to correct curly brackets and include feature attributes, I added colors to help others see the different parts (%22 is html encoding for double quotes):
"https://fieldmaps.arcgis.app/?referenceContext=addRelatedFeature&itemID=0c900ae2a1084d27b608233921ef1a84& featureSourceURL=https://services9.arcgis.com/QjGvjfQhsHAmqfjP/arcgis/rest/ services/DamageAssessment_Apr2018_631d0895e7d3404bb78e8e04e92d896e/FeatureServer/ 1&featureID="+Replace(Replace($feature.globalid,'{',''),'}','')+"&foreignKeyField=globalid&featureAttributes={%22incidentid%22:%22527%22,%22inspector%22:%22Frank Jones%22,%22inspdate%22:1502917218285%22}"

This expression is then used as the link URL in the pop-up text box content:
<p>
<a href="{expression/expr0} ">Add Inspection</a>
</p>

Re: AddRelatedFeature Url Parameter Error: Foreign key

FeichiShih2 — Thu, 08 Aug 2024 03:45:03 GMT

Hi Colin, Is it possible to pre-populate the geometry in FieldMaps by passing in the geometry in the URLparameters when referenceContext=AddRelatedFeature (Similar to how addFeature and updateFeature works)? This would be really helpful.

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Thu, 08 Aug 2024 16:01:23 GMT

Hi @FeichiShih2 , just to clarify, is the related feature you are trying to add another feature layer (not a table)? ie you may have a Feature to Feature relationship? Hypothetically it should be possible but I have not tried it. What happens when you use a link with geometry added in?

Re: AddRelatedFeature Url Parameter Error: Foreign key

ahargreaves_FW — Fri, 31 Jan 2025 15:38:56 GMT

Hello @ColinLawrence

I too am trying to add a related record but to a related featureclass, not table. Here's my setup:

https://xyzxyzx/FeatureServer/0 is parent FeatureClass
https://xyzxyzx/FeatureServer/1 is related FeatureClass (related to parent)
https://xyzxyzx/FeatureServer/2 is related Table (related to parent)

I use Arcade to generate the below URL in my popup within Field Maps:

https://fieldmaps.arcgis.app/?referenceContext=addRelatedFeature&itemID=26xxxxxxxxx38&featureSourceURL=https://xyzxyzxyzxyz/FeatureServer/0&featureID=926B718B-99AD-4400-8AF5-72DA05CC647B&foreignKeyField=FEATUREGUID">https://fieldmaps.arcgis.app/?referenceContext=addRelatedFeature&itemID=26xxxxxxxxx38&featureSourceURL=https://xyzxyzxyzxyz/FeatureServer/0&featureID=926B718B-99AD-4400-8AF5-72DA05CC647B&foreignKeyField=FEATUREGUID

This results in the https://xyzxyzx/FeatureServer/2 (related Table) being opened, when really I want

https://xyzxyzx/FeatureServer/1, the related FeatureClass...any way around this?

Re: AddRelatedFeature Url Parameter Error: Foreign key

ColinLawrence — Fri, 31 Jan 2025 18:40:53 GMT

Hi @ahargreaves_FW , I am assuming both the feature class (index 1) and table (index 2) are related back to the parent using the same key field? There is a limitation in the addRelatedFeature workflow where it looks for the first layer index with that key and will select that layer to add the related feature when Field Maps opens; this is a known limitation. However, it seems that is not what is happening in your case as it is skipping the feature class and going to the table instead. This sounds like a bug to me. Are you able to present this to technical support?