Data integration / synching

[Ojay]

Hi All,

I am trying to carry out data integration using Designer, involving a web application and Microsoft SharePoint.

I want to see the exact same data that is in the web application reflected in the SharePoint anytime I run the workflow.

Can this be done? Has anyone successfully tried this?

Regards

[jamielaird]

Outputting to SharePoint is certainly possible.

How would you be pulling data from the web application?

[Ojay]

@jamielaird

Apparently there is an API but I need to double check to be 100% sure.

Should know for certain this coming week.

[jamielaird]

In that case there shouldn't be any issues pulling the data from the API using the Download tool and writing the output to SharePoint using the SharePoint connector.

Here are some useful resources:

https://community.alteryx.com/t5/Engine-Works/REST-API-In-5-Minutes-No-Coding/ba-p/8137

https://help.alteryx.com/current/designer/sharepoint-list-output-tool 

[Ojay]

@jamielaird: Thanks. I'll give it go.