How to create a SharePoint entry

[hugomito]

Hi all,

I hope you can help me with this need. In the company I work for, every time we need to deploy a change into a Production environment, we need to add a SharePoint entry in a Calendar area. This is in order to notify Operations team that a change will be introduced on a specific date.

The fields we need to fill out are:

• ows_Project
• ows_ChangeReq
• ows_Description
• ows_StartDate
• ows_EndDate

The thing is that, I have all these values available in an AutoIT application I built called EAI Tool so, what I need is: Whenever a user click a button, a SharePoint record should be created populating SharePoint fields with the values from EAI Tool applicacion.

If you need additional information, let me know.

Regards,

[Trong]

Try a walk: https://www.autoitscript.com/autoit3/docs/

and https://www.autoitscript.com/autoit3/docs/intro/au3spy.htm

and https://www.autoitscript.com/autoit3/docs/functions/ControlClick.htm
and https://www.autoitscript.com/autoit3/docs/functions/ControlSend.htm

 

[water]

Maybe this helps. The wiki provides an UDF for Sharepoint:

Quote

Sharepoint 2007/2010 UDF (by schoppet) - UDF to access the SOAP-Webservices of Sharepoint 2007/2010.

 

[hugomito]

Thanks Trong & Water for your posts.

 

The UDF site was very helpfull to understand how SharePoint works (SharePoint.au3).  Once I understood that SharePoint had it's own web services, I created my own scripts.

 

I am attaching a SharePoint query script. I hope this helps someone else.

Regards,

SharePoint_Query_4AutoIt.au3

[ptrex]

Some more links to get you started ...

I wrote several blog posts on SharePoint and Web Services

https://audministrator.wordpress.com/2014/08/20/getting-data-from-a-web-service/

using alternative applications like Powershell and JQuery

https://audministrator.wordpress.com/2013/01/22/how-to-call-a-webservice-in-ps/

https://audministrator.wordpress.com/2015/01/24/sharepoint-using-jquery-spservices/

As you might now we can recently access PowerShell scripts from AU3... :-) Still in beta version and testing stage...

Hope this can help.