Vba to import Data into the instance?

[Naga.Naredla]

Hi All,

I have WSDL and SOAP Request, now my aim is to import the data into my application using the WSDL and the Soap Requests

Regards
Naga

 

[Chihiro]

There isn't nearly enough detail to help you here.

I'd imagine that you'd need to send XML to service. But without any details of how the document is structured... can't help you much.

Have a read of W3 school documentation on XML WSDL and see if you can construct XML from that.
https://www.w3schools.com/xml/xml_wsdl.asp

Note: SOAP in general is pain in the rear to deal with. See if there is alternate method to send requests (REST API or some other method).

 

[Naga.Naredla]

Hi Chihiro

I got the Rest API now I want to perform all the method action (Create, Update, delete )in the Instance from VBA itself below is one of the requests

https://cbfh-test.crm.us2.oraclecloud.com/crmCommonApi/resources/latest/accounts


Regards
Naga

 

[Chihiro]

Sorry but I can't open the site.

Looks like it's either Oracle Cloud or Oracle Sales Cloud API that you are working with. Then look through their documentation on API to integrate it with VBA.

https://docs.oracle.com/en/cloud/saas/sales/r13-update17d/faaps/toc.htm
https://docs.cloud.oracle.com/iaas/api/