[SalesForce] How to i Insert Data in Salesforce using WSDL file of Salesforce using Query

Query :

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

I can get data using "Select Query " in Salesforce WSDL file.
At same way can i use query based CRUD Operations in Salesforce.

QueryResult queryResult = null;
String SOQL = "";
string productid = "";   
SOQL = "select Id from Product2 where ProductCode = 'Test'";
queryResult = sfdcBinding.query(SOQL);

Best Answer

SOQL is query only. It won't perform inserts, updates, or deletes. Those are referred to as Data Manipulation Language (DML) operations instead and are handled by separate API methods.

Instead you should use create() or upsert() to create new records via the APIs.

Related Solutions

[SalesForce] Get data from SAP to Salesforce using WSDL

There is an excellent topic 'Understanding the Generated Code' in the Apex Developers guide here, which describes what your getting from the Apex2WSDL tool and an example of how to use it. Of course each Web Service is different, so I cannot comment on specifically. So here are some general observations.

Authentication? I can see that its a basic account enquiry service. It does not appear to have any authentication needs (typically these are expressed in the WSDL via soap:header's), i assume thats ok for your demo purposes.
Bulkification? If you are in control of the web service you may want to ask the author to accept a list of customer names, which will avoid you looping over them. Note that Apex has a limit of 10 maximum call outs of this kind per request. Limiting the number of records from your SAP__c table that can be processed.

Finally you should also review the support for Mocking Web Service callouts when it comes time to write some Apex tests to cover this code you will need it.

[SalesForce] Issue with passing header data on callouts using external wsdl

The soap header should be added as a member to the wsdl2apex generated stub class that corresponds to the port. This class will also have the public String endpoint_c = '...'; member.

There should also be a String member generated that ends with _hns. This has the namespace mapping for the header.

I assume you defined a value for the header member in the stub class?

Alternatively, there is also support for HTTP Headers via the inputHttpHeaders_x Map. See HTTP Header Support:

docSample.DocSamplePort stub = new docSample.DocSamplePort();
stub.inputHttpHeaders_x = new Map<String, String>();

//Setting a custom HTTP header
stub.inputHttpHeaders_x.put('myHeader', 'myValue');

When I generated the Apex classes from your WSDL the header was called ServiceName and had the type gwHeaders100.Service_element.

public class ingdirectComWsdlLoanCreateleadWsdl {
    public class loan_CreateLead_HTTPPort {
        public String endpoint_x = 'http://localhost:8080/wesp-dgw/';
        public Map<String,String> inputHttpHeaders_x;
        public Map<String,String> outputHttpHeaders_x;
        // ... snip ...
        public gwHeaders100.Service_element ServiceName; // <---- This is the input soap:header
        private String ServiceName_hns = 'Service=urn:gw-headers-100';
        private String[] ns_map_type_info = new String[]{'urn:gw-headers-100', 'gwHeaders100', 'urn:gw-message-100', 'gwMessage100', 'urn:gw-message-200', 'gwMessage200', 'http://ingdirect.com/wsdl/loan_CreateLead.wsdl', 'ingdirectComWsdlLoanCreateleadWsdl', 'urn:gw-ingdirect-services-lendingservices-contracts-common-100', 'gwIngdirectServicesLendingservicesCo', 'urn:gw-loanserviceenvelope-100', 'gwLoanserviceenvelope100'};
        // ... snip ...
    }
}

Best Answer

Related Solutions

[SalesForce] Get data from SAP to Salesforce using WSDL

[SalesForce] Issue with passing header data on callouts using external wsdl

Related Topic