cancel
Showing results for 
Search instead for 
Did you mean: 

Sharepoint List Library VBO - Odata queries

SwatiGupta
Level 2

Hi
I am trying to utilize Sharepoint List Library VBO from Digital exchange. I tried to update few records/items in sharepoint but I am facing issues with customized Odata query. I tried with different HTTP methods in my query as well PUT, POST and PATCH but it didn't work. Can you please help us to share how we can update sharepoint data and what will be customized Odata query syntax?

Here are few sample queries to pull/read data from sharepoint:
getbytitle('Test List 1')/items?$filter=(FName eq 'FNameABC')
getbytitle('Test List 1')/items?$filter=ID eq 5

But for update, no luck. Attached is the screenshot of sharepoint.
Update scenario: Update any item under FName column.




------------------------------
Swati Gupta
Senior Developer
Tyson Foods
Asia/Bengaluru
------------------------------
38 REPLIES 38

Hi Swathi - Here is my setup.

 

6507.png

Hard coded the item/value pair to show the format.

 

6508.png

 

 

6509.png

 

Error Message

 

6510.png

 

 

 

 

 

 

 

Sankar Sarma

RPA Analytics Leader


Please consider the environment before printing this e-mail.

 



------Original Message------

Hi Sankar,

The header looks like the attached file.Share the error message. Ryan has shared all the screenshots and your request should looks like 

{ '__metadata':
{ 'type': '[List Item Type Name]' },
[Item Fields and Values]
}

Thanks,
Swati 
Tyson Foods



------------------------------
Swati Gupta
Senior Developer
Tyson Foods
Asia/Kolkata
------------------------------

This issue is fixed now, problem was unwanted space in the body. also I am passing the item key/value with out double quotes.

------------------------------
Sankar Sarma
RPA Consultant
Lion Co
------------------------------

Thanks so much for sharing the solution!

------------------------------
Melanie Giuliani
Analyst
CA Technologies
America/New_York
------------------------------

HI Bimal,

I am using ODATA query to retrieve the records from sharept but query is retrieving  maximum 100 records. Is there any issue with API limited to 100 records?  If it is API limitation, can you please suggest solution. 

I have tried top filter and it is working but I can't use top filter. 

https://sharepoint.stackexchange.com/questions/74777/list-api-get-all-items-limited-to-100-rows

I have checked the item limit in sharept it is 30 so I think it is not related to this.

Thanks,
Swati


------------------------------
Swati Gupta
Senior Developer
Tyson Foods
Asia/Kolkata
------------------------------

NicholasRobbins
Level 3
​Hi, I am working on SharePoint List Library Skill API and my IT Team is concerned with setting up the client secret in Azure because they do not want our BP to have read/write to all of our company's SharePoint pages/sites. Does anyone know how we can limit the API's access, or have a workaround?                                              

------------------------------
Nicholas Robbins Leon
RPA Developer
Darden
Orlando
407-245-65206529.png
------------------------------

I did tried the same web API config however getting 407 Proxy authentication required issue.  Do you know how to fixed this issue ? or Can someone please help me to get the actions to get the Form digest value ?

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

Hi Ryan,

I did tried the same web API config however getting 407 Proxy authentication required issue.  Do you know how to fixed this issue ? or Can you please help me to get the actions to get the Form digest value ?

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

Hi Ryan,

Could you please help.

@Bimal Sebastian - Hi Bimal, Will you be able to help me with this part to perform operations like Get Data, Edit Field/Column on SharePoint Online list.​

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

VinayaShastry
Level 3
Can you send me a link to download SharePoint List Library VBO from DX?

------------------------------
Vinaya Shastry
------------------------------

How do you get Form Digest Value in SharePoint 2016?

------------------------------
Vinaya Shastry
------------------------------