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?
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
9 freelancers are bidding on average $64 for this job
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.