Unable to pull Date columns from sharepoint

[Saravanan13]

Hello all,

I am trying to pull data from SharePoint, When I tried to pull using SharePoint list input tool I don't have any issue in pulling the date fields but  I am using a EPV macro for the same, the date fields are pulling as nulls. Can anyone assist with this.

[gautiergodard]

Hey @Saravanan13 

One to avoid having to use an EPV macro is to turn your SharePoint list into an app.

Once thats done, you can use the client ID and secret key to authenticate:

Here is a good video I've used to guide through the process of generating a client ID and secret key: https://www.youtube.com/watch?v=YMliU4vB_YM&t=740s.

You can start around 7:25minute mark.