nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Viewing Related Records in attribute table Web AppBuilder

ChristopherSchreiber

Hello all,

I am trying to view related data in the attribute table widget in Web AppBuilder. It is a one-to-many relationship and everything works fine on the ArcGIS Online webmap. When I try the same thing in Web AppBuilder, the Attribute table widget comes back with "No related records found" but I know that there are records. The related records are stored in a table that is hosted on ArcGIS Online.

When I open the browser dev tools I see this error:

Error: Invalid URL

I do not have the table showing in the attribute table by default. I am not sure if this is causing the issue.

Thanks!

Chris

Finde mehr Beiträge mit dem Tag

Accepted answers

ChristopherSchreiber

Hello all,

I contacted Esri support and they were able to help me with this issue.

The problem was not the proxy, the reason that I was getting "Invalid URL" errors in the console was because the app was changing the URL from

www.myorg.maps.arcgis.com/<orgcode>/arcgis/rest/services/<service>/FeatureServer/0

www.myorg.maps.arcgis.com/<orgcode>/arcgis/rest/services/<service>/MapServer/0

Map services cannot be hosted on ArcGIS Online, so this was causing my error.

Tech support and I looked at apps hosted on AGOL and were not able to reproduce this error. This seems to be an issue with Web AppBuilder Developer Edition Version 2.1. ArcGIS Online is running the next version of WAB.

The helpful folks at Esri support were able to provide a work-around for the issue:

In the proxy.ashx file, add the following (around line 114):

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//if url is encoded, decode it.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"http%3a%2f%2f"</SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"https%3a%2f%2f"</SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; uri <SPAN class="operator token">=</SPAN> HttpUtility<SPAN class="punctuation token">.</SPAN><SPAN class="token function">UrlDecode</SPAN><SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//Esri Support work around</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token"><SPAN>"</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2F" target="_blank">https://services.arcgis.com/</A><SPAN><orgcode>/arcgis/rest/services/<MyService>/MapServer"</SPAN></SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; uri <SPAN class="operator token">=</SPAN> uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MapServer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FeatureServer"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//End Work around</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>TraceLevel<SPAN class="punctuation token">.</SPAN>Info<SPAN class="punctuation token">,</SPAN> uri<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ServerUrl serverUrl<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN> <SPAN class="punctuation token">{</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This addition basically waits for this URL to pass through the proxy and then when it sees it, it replaces 'MapServer' with 'FeatureServer' and sends it on its merry way.

Esri support created bug for the issue:

#BUG-000099764

Fail to query related table from web appbuilder app, the request is made through Map Server instead of Feature Server after applying proxy to the app

Thanks!

Chris

All comments

ChristopherSchreiber

Hello all,

I found this solution for those applications that do not use a proxy.

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//working around an arcgis server feature service bug.&nbsp; Requests to queryRelatedRecords operation fail with feature service 10.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//Detect if request conatins the queryRelatedRecords operation and then change the source url for that request to the corresponding mapservice</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; esriRequest<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setRequestPreCallback</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>ioArgs<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>ioArgs<SPAN class="punctuation token">.</SPAN>url<SPAN class="punctuation token">.</SPAN><SPAN class="token function">indexOf</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"queryRelatedRecords"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">!==</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ioArgs<SPAN class="punctuation token">.</SPAN>url <SPAN class="operator token">=</SPAN> ioArgs<SPAN class="punctuation token">.</SPAN>url<SPAN class="punctuation token">.</SPAN><SPAN class="token function">replace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FeatureServer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MapServer"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> ioArgs<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It intercepts the request like the proxy and changes the URL.

This was found on this site: Query and edit related records | ArcGIS API for JavaScript 3.20

Thanks,

Chris

ChristopherSchreiber

Update:

Here is the link to the bug:

BUG-000099764: Querying a related table in Web AppBuilder for ArcGI..

ChristopherSchreiber

Hello all,

I contacted Esri support and they were able to help me with this issue.

The problem was not the proxy, the reason that I was getting "Invalid URL" errors in the console was because the app was changing the URL from

www.myorg.maps.arcgis.com/<orgcode>/arcgis/rest/services/<service>/FeatureServer/0

www.myorg.maps.arcgis.com/<orgcode>/arcgis/rest/services/<service>/MapServer/0

Map services cannot be hosted on ArcGIS Online, so this was causing my error.

The helpful folks at Esri support were able to provide a work-around for the issue:

In the proxy.ashx file, add the following (around line 114):

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//if url is encoded, decode it.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"http%3a%2f%2f"</SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"https%3a%2f%2f"</SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; uri <SPAN class="operator token">=</SPAN> HttpUtility<SPAN class="punctuation token">.</SPAN><SPAN class="token function">UrlDecode</SPAN><SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//Esri Support work around</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">StartsWith</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token"><SPAN>"</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2F" target="_blank">https://services.arcgis.com/</A><SPAN><orgcode>/arcgis/rest/services/<MyService>/MapServer"</SPAN></SPAN><SPAN class="punctuation token">,</SPAN> StringComparison<SPAN class="punctuation token">.</SPAN>InvariantCultureIgnoreCase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; uri <SPAN class="operator token">=</SPAN> uri<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MapServer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FeatureServer"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//End Work around</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>TraceLevel<SPAN class="punctuation token">.</SPAN>Info<SPAN class="punctuation token">,</SPAN> uri<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ServerUrl serverUrl<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN> <SPAN class="punctuation token">{</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This addition basically waits for this URL to pass through the proxy and then when it sees it, it replaces 'MapServer' with 'FeatureServer' and sends it on its merry way.

Esri support created bug for the issue:

#BUG-000099764

Fail to query related table from web appbuilder app, the request is made through Map Server instead of Feature Server after applying proxy to the app

Thanks!

Chris

ChristopherSchreiber

Thanks Robert,

I will give them a call.

Chris

RobertScheitlin__GISP

Christopher,

I believe that this is a known Proxy issue with passing tokens. I would give tech support a call to confirm.

ChristopherSchreiber

Hello all,

I have been working on this and I think I found out why I am having issues.

After comparing the network traffic with Fiddler web debugger between the app that is not working and one on AGOL that works, I found that the difference between the tow was that the local app (not working one) was using a proxy and the proxy was not including a token on the end of the URL.

This is further confirmed when I run the app with out any proxy settings and log in when it loads. If I do it this way, no issues, but when I use the proxy, it will not load related data.

If anyone has come across this issue and worked around it, please let me know.

Thanks!

Chris

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.