SharePoint REST api Input string was not in a correct format

Question

I'm fairly new to SharePoint and have been wrestling with this particular problem for some time now. Whenever I try using the REST API for a calendar list using the following url

/<my_domain>//_api/web/lists/getbytitle('Class%20Sessions')/items?

it fails and returns the following:

 <m:error
 xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
 <m:code>-1, System.FormatException</m:code> <m:message
 xml:lang="en-US">Input string was not in a correct format.</m:message>
 </m:error>

The same format for all the rest of my lists that are non calendar type work just fine. I know I am not misspelling the list name and it does exist. I feel that there is something fundamentally wrong. Is there something special that I need to do for the calendar type list?

Any help to point me to the right direction will be greatly appreciated.

Have you tried /_api/web/lists(guid'list GUID')? Just for testing — cubanGuy
– cubanGuy, Commented Feb 24, 2015 at 17:58
If he title of the list contains a space you can leave it as ('Class Sessions') and will work. — Steve Curran
– Steve Curran, Commented Feb 25, 2015 at 15:12
Awesome! It work to perfection. Although I do wonder why it was a problem in the first place? — Adrian Garcia
– Adrian Garcia, Commented Feb 26, 2015 at 13:41

egidiocs · Accepted Answer · 2016-09-09 17:41:12Z

1

I faced this scenario, and the problem was related to a incorrect Field definition.

answered Sep 9, 2016 at 17:41

egidiocs

4765 silver badges14 bronze badges

Add a comment |

John Zachariah · Accepted Answer · 2017-08-26 16:13:32Z

1

Late reply, but still may be useful for someone:

I've noticed %20 in input string - please be aware that SP marks spaces as 'x0020', so 'Class_x0020_Sessions' should work.

TIP: Underscore is marked as 'x005f'

edited Aug 26, 2017 at 16:13

John Zachariah

1,1611 gold badge12 silver badges31 bronze badges

answered Aug 25, 2017 at 14:34

Bartosz Dalak

211 silver badge3 bronze badges

Add a comment |

Phil Greer · Accepted Answer · 2015-02-26 14:03:45Z

0

I still don't know what the problem was exactly but Cubanguy's suggestion worked just fine. Instead of using the getByTitle('ClassS')/fields read operation I used _api/web/lists(guid'<list id>').

It was a simple fix to an odd problem. Thank you!

edited Feb 26, 2015 at 14:03

Phil Greer

2,2879 gold badges21 silver badges23 bronze badges

answered Feb 26, 2015 at 13:47

Adrian Garcia

2671 gold badge4 silver badges10 bronze badges

I am facing the same issue, while i Use rest to get a list data in my client web-part / App-Part in SP2013 i get the same error.

Vishwas Goswami
– Vishwas Goswami

2015-09-21 06:52:37 +00:00
Commented Sep 21, 2015 at 6:52

Add a comment |

Stack Exchange Network

SharePoint REST api Input string was not in a correct format

3 Answers 3

Your Answer

Hot Network Questions

SharePoint REST api Input string was not in a correct format

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions