abhilashpatnaik
Design Dabbler

How to update the hidden columns of list using Nintex workflow

Jump to solution

Wanted to know if there is any way I can update the hidden internal columns of a list as in the dropdown it does not show any of those.

 

I am Using nintex 2016 on prem not online . All the post i find using using REST api update points to nintex13 or online which does not valid to 2016.

 

I am trying to update the ParentID column in task list which is hidden by default to a value 

0 Kudos
Reply
9 Replies
eiben
Design Canvas Artiste

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

Have you tried using the REST api with SharePoint 2016? I don't see any reason why this should not work, since the REST api has been available since SharePoint 2013 it is most certainly part of SharePoint 2016 as well - even though there might not be as many postings.

0 Kudos
Reply
abhilashpatnaik
Design Dabbler

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution
Could you please point me up to nintex 2016 rest api update help documentation as 2013 steps and ui seems to be different than 2016 nintex
0 Kudos
Reply
eiben
Design Canvas Artiste

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

Hi,

 

do you want to update a sharepoint list-item or do you want to update some Nintex-specific data? If you want to do the first, you need to call the SharePoint REST API not the Nintex REST API.

You can find some information about the SharePoint REST API at https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service. This is not specific to any version of SharePoint, but does work with SharePoint 2016.

So potential workflow could look like this:

ntx_wf_01.png

In order to update a list-item you have to do something like this:

ntx_wf_02.png

0 Kudos
Reply
abhilashpatnaik
Design Dabbler

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

Thanks for replying, I know the sharepoint rest api, but my problem is with Nintex 2016, The image you have shown is different from my version and want to know how to use teh sharepoint rest api inm y version of nintex . Find below the screenshot of the Nintex 2016. Is there any documentation which shows how I can use the Rest api in below Version of Nintex. The webmethod is always blank as its expecting soap i believe


nintex.png

0 Kudos
Reply
abhilashpatnaik
Design Dabbler

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

I guess have to use the web request rather than call webservice, Will try the post method and log to see the updateNIntex1.png

 

0 Kudos
Reply
eiben
Design Canvas Artiste

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

That's a different action! There are actually two actions for requests: the "call web service" as well as the "web request". If you want to interact with the REST API you will have to use the latter, because the "call web service"-action can only call SOAP-based web-services.

ntx_he_003.png

0 Kudos
Reply
abhilashpatnaik
Design Dabbler

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

Thanks, I have tried following the post here to update a column 
https://community.nintex.com/t5/Community-Blogs/How-to-execute-a-SP2013-REST-API-request-with-Nintex...
also followed your screenshot but I am getting the below error not sure where am doing wrongNintex2.png

 

Nintex3.png

 

0 Kudos
Reply
eiben
Design Canvas Artiste

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

What's the value of the workflow-variable "formDigest"? You need to have a valid formdigest in order to update a list-item. If you want to test the service-call you have to substitute a valid value, as the "run-now" function does not resolve variables.

0 Kudos
Reply
abhilashpatnaik
Design Dabbler

Re: How to update the hidden columns of list using Nintex workflow

Jump to solution

Thanks @eiben  for all the help. Posting the answer here that worked for me, for anyone coming here on how to update the hidden column parent ID in task list on high level . Hope this helps someone come looking to update the hidden column in task list
1.png

 

2.png

 

3.png

You can get the ListItemEntityTypeFullName from this - <site>/_api/web/lists/getbytitle('List Name')?$select=ListItemEntityTypeFullName4.png

 

View solution in original post

0 Kudos
Reply