We have a requirement to integrate Salesforce Marketing cloud with an Third Party System (like AOP) and fetch bulk data from there and store it in a Data Extension.
Can you please help me with answer to the below queries :
1) API Approach - if we will be using the soap API to fetch the bulk data from the third party system into SFMC
i) Can we use Server Side Java script Activity in Automation studio to schedule the API to run hourly ? and can the SOAP API be fetch the data be written in the Server Side Java script ?
Can you also please suggest any other approach other than FTP transfer to implement this requirement in SFMC.