In Progress

SharePoint list field populated from REST query response

I'm in search of steps to accomplish the following. I have a monitoring API query that returns response body containing a value between 0 to 100. I want to create a SharePoint list field that will store the value that API call.

For instance, imagine I have a SharePoint list of 3 rows.

Row 1 calls the API and returns the value 90

Row 2 calls the API and returns the value 60 Row 2 calls the API and returns the value 40

I would like a column in the list to surface these values.

Ideally, what I will do with these values is this. If the value is 90, I will show a GREEN status image in a status column of type image. If the value is 60, I will show a YELLOW status image in a status column of type image. If the value is 40, I will show a RED status image in a status column of type image.

What I'm struggling to find through basic Google and Bing searches are any code that illustrates how and where an API query can be executed for every row in a SharePoint list and populate a column, say text OR numeric column

................................

BY THE WAY, I haven't written my API function yet but my intent is to simply return a number between 0 to 100 in the response body. But I'd be curious to know how the guidance would change if the response body is fixed in JSON format. Can someone provide additional tips to parse the JSON body to retract the 90, 60 and 40 values?

Thanks

If you read this far add the words "SHAREPOINT ACCOMPLISHED" to your bid, otherwise I will not review it and discard of your bid immediately. Better yet, link me to an example you have previously implemented to win the bid. Whether it be live or a doc.

THE PROJECT REQUIREMENTS HAVE BEEN UPDATED AND UPLOADED IN THE FILE SHAREPOINTPROJECT.HTML

FREELANCERS MUST REVIEW, COMMENT, CLARIFY BEFORE MAKING A BID

WITHOUT DOING SO, PROPOSALS WILL NOT BE HONORED

Skills: Javascript, Sharepoint

See more: sharepoint 2013 rest api lookup field, sharepoint 2013 rest api get list fields, fieldtypekind sharepoint, sharepoint rest api fields, the $select query string must specify the target fields and the $expand query string must contains, sharepoint rest api list fields, sharepoint rest expand user field, sharepoint rest api select fields, rest call sharepoint list infopath, sharepoint list populated word form, sharepoint list query webpart, query builder sharepoint list, custom field type sharepoint list file uploading, sharepoint list view custom field, sharepoint list field combo box

About the Employer:
( 28 reviews ) Bellevue, United States

Project ID: #14943575

Awarded to:

Hjethva123

Sharepoint accomplished - As I understand your requirement you need to show red green icon on view based on some number values I have already work on this type of solution previously if you assign this task to me we ca More

$66 USD in 2 days
(1 Review)
1.8

10 freelancers are bidding on average $102 for this job

viveksoni89

SharePoint developer with an overall of 6 years of experience varying from finance to service to core IT industrial projects. As per your requirement I had been catering such services in the organization for years. So More

$132 USD in 5 days
(1 Review)
3.2
unikinfoways

Hello Sir, I have read your requirement and we will happy to allocate our best experienced developer to SharePoint list field populated from REST query response Let's discuss further in details. Awaiting for you More

$111 USD in 2 days
(2 Reviews)
3.1
$25 USD in 1 day
(2 Reviews)
1.4
MetaoriginLab

We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in More

$126 USD in 3 days
(2 Reviews)
0.9
RushService

Feel fee to contact me [url removed, login to view] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [url removed, login to view] payment only after the work [url removed, login to view] yo More

$30 USD in 1 day
(1 Review)
0.0
YoursProTech9

SHAREPOINT ACCOMPLISHED I have gone through your description and understand your [url removed, login to view] we can create a SharePoint list field that will store the value that API [url removed, login to view] have work with the similar type of More

$444 USD in 3 days
(0 Reviews)
0.0
$35 USD in 1 day
(0 Reviews)
0.0
TaurusQ

Hello! I do not know yet what exactly I will give you, but I'm sure that with this you can do it qualitatively, since SharePoint is our profile since 2011 Соответствующие навыки и опыт MS SharePoint 2010/2013/2016/Onl More

$25 USD in 40 days
(0 Reviews)
0.0
rodsuiterx19825

I can handle this one well using Sharepoint REST, jQuery and CSS . This is just a small project that i can easily finish. Let's just discuss further the details of your project. I am excited to work with you.

$25 USD in 1 day
(0 Reviews)
0.0