Pull Functionality using a service layer

Question

Hi Experts

I have published non spatial table  and generated a token to use it and its looks like this and its publicly shared

Now I want to pull the information from service when searched in the project code with a value available in service and corresponding other 2 fields should be autopopulated when selected or entered

How can i achieve
Service url : https://services8.arcgis.com/opMNag2LPyZVnSsz/ArcGIS/rest/services/KBD_Project_Code_v2/FeatureServer/0?token=mzFcMRqhxzPAoRJavp2MJhC3VemhqtZExkV_sXjGVL1Nk1Lih9ZXglxR80sV62mr4MJxRLG0M2GFpcmtmcmTVoJ4RgdouO0bPwbWwHHVKkzOgdMueddLGZM_P-W_I_h7VNb6HMlJQpFzc0-wFba2qx7-OjQ7EtLGGS9h_xuOH5bG7B5v3JxZvtH9NnR6Cf1U

Kindly Guide me or correct me with the correction

Highly Appreciate the support @ISM

Attched the xls

test_20240839.xlsx

Screenshot 2025-01-10 084035.png

AbdulabnanMohammed · Answer

Thank You

Hi
I have successfully implemented this scenario but with changes to spatial data feature service instead of hosted feature service table with same fields are there in both

But why it doesnt work with non spatial data because i have list from 2017 to till update which i need to design but hosted service table doesnt work

Is this the issue of authentication , I tried with postman also any suggestion please to correct

Attached the working xls designed for spatial data service file
Any Guidance or any sample form 
@DougBrowning

@IsmaelChivite

ABNAN_PULL.xlsx

dougbrowning · Answer

You need "" around the URL when moving to calculation.  I attached a sample before.

AbdulabnanMohammed · Answer

Thank You so much for the quick response

Receiving below error

I'm receiving this error once i moved calculation column and also how can i pull other 2 fields(Client name and project name) based on  project code

Thanks