Skip to main content
Nintex Community Menu Bar
Solved

SharePoint REST API getbytitle with ampersand in title?

  • Sep 13, 2017 7:28 PM UTC
  • 10 replies
  • 213 views
  • Translate All

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) .

View original

10 replies

TomaszPoszytek
Forum|alt.badge.img+17

Forum|alt.badge.img+4
  • Author
  • Sep 13, 2017 8:07 PM UTC

Hi Tomasz ,

Thank you for your response .

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

So I submitted my question here ..

Translate

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
Translate

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?

Translate

Forum|alt.badge.img+4
  • Author
  • Sep 14, 2017 2:49 PM UTC

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 .

Translate

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

‌ ‌ ‌ ‌ ‌ ‌

Translate

Forum|alt.badge.img+7
  • Nintex Partner
  • Sep 15, 2017 3:00 PM UTC

try to replace the & with %26

Translate

TomaszPoszytek
Forum|alt.badge.img+17

Hi ‌ - have you managed to make it work?

Regards,

Tomasz

Translate

Forum|alt.badge.img+4
  • Author
  • Answer
  • Oct 4, 2017 9:38 PM UTC

Hi Tomasz ,

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

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

Translate

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

Translate