Accessing Sharepoint List

[roland-daane]

Hi,

I'm looking what you need to do to lookup values in a Sharepoint list, and et them into variables for a recipe.

I can search the list, and see the values in the Job, but I can't seem to access them.

[ngeorgakopoulos]

Maybe you should provide a response body sample in the custom action?

[roland-daane]

I have this in the response body:

[

{

"name": "Project",

"type": "string",

"optional": true,

"control_type": "text"

}

]

[ngeorgakopoulos]

This looks like the input parameters that the action needs (Project). I was thinking about the response body that looks like

[sanjay-rathod1]

Roland Daane

From the attached Screen-shots, I thought you have used the Custom Action of the Sharepoint.

The Custom action mainly have following fields to setup:

Action name, Method, Path, Response Type, Request Parameter and Response body.

From the Screen-shot, I observed that you are getting the response from Sharepoint side, means you request Method, Path and parameters are looks good.

Now, to use the result from custom action you just need to set the JSON into the Response Body field of custom action.

As easy approach, just copy the JSON by cliking the "Copy JSON" button from the job result or you can also copy the Response JSON from the Sharepoint API documentation for that request.

For more information about Custom Action and how to setup action parameters, you can follow the steps as given example in the following Workato document:

https://docs.workato.com/developing-connectors/custom-actions.html#custom-actions

Thank you.