topic Re: Accessing Sharepoint List in Workato Pros Discussion Board

Accessing Sharepoint List

roland-daane — Tue, 26 Oct 2021 15:15:19 GMT

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.

Re: Accessing Sharepoint List

ngeorgakopoulos — Tue, 26 Oct 2021 15:44:53 GMT

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

Re: Accessing Sharepoint List

roland-daane — Tue, 26 Oct 2021 15:54:19 GMT

I have this in the response body:

[

{

"name": "Project",

"type": "string",

"optional": true,

"control_type": "text"

}

]

Re: Accessing Sharepoint List

ngeorgakopoulos — Tue, 26 Oct 2021 16:03:16 GMT

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

Re: Accessing Sharepoint List

sanjay-rathod1 — Tue, 26 Oct 2021 16:33:37 GMT

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.

Re: Accessing Sharepoint List

vinny-sosa — Tue, 26 Oct 2021 18:25:13 GMT

You can’t just ass a list to a variable. The connector brings back a list. What is it that you want to do with the list? If you want to add it to a Google sheet you can do that straight away with the Google sheet connector… for example. If you want to look for a specific person use the repeat action on the list until you find the person(s) that meet(s) your criteria… say create date time stamp is less than 5 minutes ago or something. Then do something with each of those people (I.e.) maybe add them to another system or send them and email or something.

Re: Accessing Sharepoint List

roland-daane — Tue, 26 Oct 2021 18:31:45 GMT

I want to compare it with the part in the filename to valicate if the filename is correct.

Say filename is BC12324-XX-YY-Z-BQ-A-001 the BC1234 is project.

In the Sharepoint list I want to pick up the Project, and if Projectcode from filename exists in projectcode from Sharpeoint, then it's okay.

Re: Accessing Sharepoint List

roland-daane — Tue, 26 Oct 2021 18:36:54 GMT

Hi,

I pasted this into the response body:

{

"name": "project",

"type": "string",

"optional": true,

"label": "Project",

"control_type": "text"

}

But I'm still not ableto pick up the value from the sharepoint list into a variable

Re: Accessing Sharepoint List

sanjay-rathod1 — Tue, 26 Oct 2021 19:12:38 GMT

Roland, the fields you have set up in the response body are not matched with the API response.

Copy the JSON by clicking on the "Copy JSON" button of the following screen:

After copying JSON, go to the Custom Action.

Clear the Response body you have setup.

Then click to "Use JSON" from Response Body field.

Popup will appear.

Remove the Empty Brackets from "JSON Sample" area.

Paste the JSON here

Click to next > Then Click to "Generate Schema"

------

By following these steps, you will get the API response variables to the next steps, and use it further for comparision.

P.S. If your response may contain an array of data, then you also need to do a Loop (Repeat action) to walk through each record.

Re: Accessing Sharepoint List

mroldanvega — Tue, 26 Oct 2021 19:18:06 GMT

You could also take the list and add it to a collection Roland Daane , this way you don't need to loop through them.

Re: Accessing Sharepoint List

roland-daane — Tue, 26 Oct 2021 21:56:38 GMT

Brilliant, thanks!!!

I now have the project in the oploaded filename, and can validate against the value in the list.

I'm going to be playing around with this much more.

Thanxx

Re: Accessing Sharepoint List

vinny-sosa — Wed, 27 Oct 2021 20:32:00 GMT

You would repeat through the share point list and compare each value in the list to the name of the file using ‘if’ and ‘contains’. You can also do this comparison using a logger step with a function in it whose output is a true or false. In either case you need a repeat step to loop through the items of the array.