Skip to main content
Nintex Community Menu Bar
Solved

SharePoint REST API getbytitle with ampersand in title?

  • September 13, 2017
  • 10 replies
  • 172 views

Forum|alt.badge.img+4

Hi ,

 

I am trying to query SharePoint list using Nintex workflow Web API. It is working fine for all the lists except in the list title.

Tried below , nothing worked .

 

AB&C Company

AB&C Company

AB%26C%20Company .

 

Please suggest ...

Best answer by raghavat

Hi Tomasz ,

After I tried all the options and nothing worked out for me . 

I created a new list without having & (ampersand) .

10 replies

TomaszPoszytek
Forum|alt.badge.img+17

Forum|alt.badge.img+4
  • Author
  • September 13, 2017

Hi Tomasz ,

Thank you for your response .

Yes I tried both of them . Nothing worked for me ..

So I submitted my question here ..


TomaszPoszytek
Forum|alt.badge.img+17

I found that one as well. Haven' tried myself, but Microsoft community claims it works:

Maybe this is something you can try out too. Maybe other on the forum have their suggestions?
Regards,
Tomasz

TomaszPoszytek
Forum|alt.badge.img+17

I mean - I know you have already tried with %26, but maybe there is something else in your REST call you are missing? Maybe the ampersand is not the reason? What errors do you get? What is your query string, that you use for calls? Can you share it?


Forum|alt.badge.img+4
  • Author
  • September 14, 2017

I created a new List named ABC Company (With out & ) it worked fine without any issues .

The only issue is coming up with & . So Need a solution .


Forum|alt.badge.img+7

Hi raghava t

Try /_api/lists/getbytitle('AB%20&%20C%20Company')

or

/_api/lists/getbytitle('"+encodeURI('AB & C Company')+"')

Hope this helps


Forum|alt.badge.img+7
  • Novice
  • September 15, 2017

try to replace the & with %26


TomaszPoszytek
Forum|alt.badge.img+17

Hi ‌ - have you managed to make it work?

Regards,

Tomasz


Forum|alt.badge.img+4
  • Author
  • Answer
  • October 4, 2017

Hi Tomasz ,

After I tried all the options and nothing worked out for me . 

I created a new list without having & (ampersand) .


TomaszPoszytek
Forum|alt.badge.img+17

I wonder why none from the suggested replacements worked... Maybe there is a bug in Nintex parsing the query... Dunno

I'm glad you worked it out. Can you mark any from the above answers as correct (or yours), or in case not - I will just mark the post as "assumed answered".

Regards,

Tomasz