MercuryAPI
Click here for a complete list of operations.
UpdateInvoicesFromSpreadsheet
Updates invoices based on an uploaded spreadsheet.
Test
To test the operation using the HTTP POST protocol, click the 'Invoke' button.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /mercuryapi.asmx HTTP/1.1 Host: www.mercurynetworkapi.com Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://alamode.com/UpdateInvoicesFromSpreadsheet" <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <UpdateInvoicesFromSpreadsheet xmlns="http://alamode.com/"> <UserName>string</UserName> <Password>string</Password> <Base64Spreadsheet>string</Base64Spreadsheet> <FileType>string</FileType> <CreateInvoice>boolean</CreateInvoice> </UpdateInvoicesFromSpreadsheet> </soap:Body> </soap:Envelope>
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <UpdateInvoicesFromSpreadsheetResponse xmlns="http://alamode.com/"> <UpdateInvoicesFromSpreadsheetResult> <Base64Return>string</Base64Return> </UpdateInvoicesFromSpreadsheetResult> </UpdateInvoicesFromSpreadsheetResponse> </soap:Body> </soap:Envelope>
SOAP 1.2
The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.
POST /mercuryapi.asmx HTTP/1.1 Host: www.mercurynetworkapi.com Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <UpdateInvoicesFromSpreadsheet xmlns="http://alamode.com/"> <UserName>string</UserName> <Password>string</Password> <Base64Spreadsheet>string</Base64Spreadsheet> <FileType>string</FileType> <CreateInvoice>boolean</CreateInvoice> </UpdateInvoicesFromSpreadsheet> </soap12:Body> </soap12:Envelope>
HTTP/1.1 200 OK Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <UpdateInvoicesFromSpreadsheetResponse xmlns="http://alamode.com/"> <UpdateInvoicesFromSpreadsheetResult> <Base64Return>string</Base64Return> </UpdateInvoicesFromSpreadsheetResult> </UpdateInvoicesFromSpreadsheetResponse> </soap12:Body> </soap12:Envelope>
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
GET /mercuryapi.asmx/UpdateInvoicesFromSpreadsheet?UserName=string&Password=string&Base64Spreadsheet=string&FileType=string&CreateInvoice=string HTTP/1.1 Host: www.mercurynetworkapi.com
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <UpdateInvoicesFromSpreadsheetResult xmlns="http://alamode.com/"> <Base64Return>string</Base64Return> </UpdateInvoicesFromSpreadsheetResult>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /mercuryapi.asmx/UpdateInvoicesFromSpreadsheet HTTP/1.1 Host: www.mercurynetworkapi.com Content-Type: application/x-www-form-urlencoded Content-Length: length UserName=string&Password=string&Base64Spreadsheet=string&FileType=string&CreateInvoice=string
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <UpdateInvoicesFromSpreadsheetResult xmlns="http://alamode.com/"> <Base64Return>string</Base64Return> </UpdateInvoicesFromSpreadsheetResult>