soap

Hi, I am hoping someone can help! I am trying to set up a spreadsheet for an online business that updates the 'cost of purchase' depending on which stock order has been sold. For example, if I order 10 units of soap at $10 then the cost is $10. If I make a second order of 10 soaps at $12...

Hi folks, hope someone can guide me please. I have a spreadsheet with 900+ rows of data which is concatenated to a point where I have a fully-formed SOAP request in column W for each row. Is there a way that I can either send all of these SOAP requests in one go (which would be great for the...

Hi All Sorry if this has been requested, i went through the previous posts, but i cant find the answer im looking for Can anyone please help me with the following: I want to make a soap database query using VBA, and then dump the report in excel readable sheet This is my soap scrip form...

Hello, I am new to web services, and I am trying to connect to DHL timetable WS. https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx The WSDL can be found here: https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx?wsdl When I connect through SoapUI 5.4.0, I can send requests and recieve...

Hello Everyone! I'm about to join a company that sells retail products through its stores. Hence, they should have data available on their customers shopping quite easily. For Example: The billing data shows that a customer buys soap, shampoo and potatoes; another buys shampoo, soap and...

Hi Experts, I am trying to upload excel file into SharePoint 2013 custom list's item. I am using SOAP in VBA. I am unable to identify, how to convert my excel file into base64Binary format file using VBA code so that it can upload into SharePoint custom list. Below is the code which I am...

Hi Experts, I am trying to upload excel file into SharePoint 2013 custom list's item. I am using SOAP in VBA. I am unable to identify, how to convert my excel file into base64Binary format file using VBA code so that it can upload into SharePoint custom list. Below is the code which I am...

Hello, I'm struggling with combining SP and Excel. I've got a document lib. on SP with metadata FileName/Checked Out To/Modified by in normal view. My macro is going to open one of these files stored on SP. What I need to do is to verify if file, which I'd like to open, is Checked Out and, if...

I have created the below code.. Sub VATCHECK() Dim sURL As String Dim sEnv As String Dim xmlhttp As New MSXML2.xmlhttp Dim xmlDoc As New MSXML2.DOMDocument 'DOMDocument sURL = "http://ec.europa.eu/taxation_customs/vies/services/checkVatService" sEnv = "<?xml...

Hi All, I want to implement a macro, that can run a SOAP statement (present in the file itself), and send the values present in the excel file to a particular system. Let me break it down for you: 1) there is an excel file with data on something...say Sales Calls made by a Sales Rep 2) there...

Hi, I'm gonna try to pull data into MsExcel using an API. I have the choice between REST or SOAP, what's best? Any code example somewhere? Although, to call the API I will need to provide my password in clear. Is there a way to protect (password?) the part of the code running the API? Thank you

Hi, I'm trying to connect to a web service using excel. I have currently no issues logging into the web service and also fetching data using one of the methods. But the two other methods, I get the error that states that it had run into an error restoring data. There are 4 main method...