0

I am using Rest API in an a web application using JavaScript, JQuery, and HTML and I'm having issues with pulling phone numbers. I have 3 phone number fields and they all show similar to this <d:Phone_2 m:null="true" /> in the XML of this query

https://mysharepointsite/_api/web/lists/getbytitle('mysharepointlist')/items?

They are all Single line of text fields. How can I retrieve the values?

  • Are you saying that the phone numbers for those items are not null and the query is specifying them as null? What is the problem exactly? What are you expecting to get? – Mike May 4 '16 at 13:37
  • Is there any particular reason why you want to work with XML instead of JSON? set xhr.responseType = 'json'; (this is plain JavaScript.. I don't know the $.ajax syntax) – Danny '365CSI' Engelman May 4 '16 at 15:44
  • I found that the issue was due to the field being null in most places. I added text in the fields and it seemed to resolve the issue. – user1330008 May 13 '16 at 15:45
0

I do recommend you use the SharePoint 2013 Search Query Tool and it will give you a complete list of all the list columns and more and you can always see your mapped properties, etc... working with the REST endPoint,sometimes tricky in the browser.

Here is the link to the tool: https://sp2013searchtool.codeplex.com/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.