Hi,

I am using curl to query and return many rows from a table. I am getting a curl return code of 18 which says that the size of the file expected was not the same as was recieved.

If I add a LIMIT 10 to the (SOQL) query then it runs fine and I get a results file.

I know I will have to use querymore after the initial call but I need to get the query locator.

I have googled but not been able to find a resolution to this issue - Can anyone help?

Thanks,

Hi,

I am trying to use the API to get deleted tasks.

I initiate the request :-

<?xml version="1.0" encoding="UTF-8"?>

<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">

<operation>getDeleted</operation>

<contentType>XML</contentType>

</jobInfo>

And then try to create a request :-

<?xml version=\"1.0\" encoding=\"utf-8\"?>

<sObjects xmlns=\"http://www.force.com/2009/06/asyncapi/dataload\">

<sObjectType>Task</sObjectType>

<startDate>2011-12-31 00:00:00</startDate>

<endDate>2012-01-04 00:00:00</endDate>

</sObjects>

but it seems 'getDeleted' nor 'getdeleted' works. I have tried different combinations of post I have found in the forum without luck. :-(. I am not sure if I need the asyncapi/dataload to get deleted tasks?

Can someone direct me in the right direction?

Hi,

I am trying to return a list of deleted tasks via the bulk API but only seem to get one row returned.

My query :-

SELECT Id, IsDeleted from Task where IsDeleted=true

I have tried the 'queryall' option when initiating the job but get an error.

Ny job init :-

<?xml version="1.0" encoding="UTF-8"?>

<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">

<operation>query</operation>

<object>Task</object>

<concurrencyMode>Parallel</concurrencyMode>

<contentType>XML</contentType>

</jobInfo>

Do I have to specify a date range?

Thanks,

Hi,

I am just wondering if you can have multiple queries in the bulk API request?

An example might be :-

<queryString>select id from Sales_Order_Line__c where Asset__c = '02iV00000002kdTIAQ' order by Order_Date_Time__c, Order_Line_ID__c ASC limit 1</queryString>

<queryString>select id from Sales_Order_Line__c where Asset__c = '02iV00000002kdTIAQ' order by Order_Date_Time__c, Order_Line_ID__c DESC limit 1</queryString>

.

.

I know each request will only return one row.

I the documentation there is noly an example of a query returning multiple rows.

Thanks,

Hi,

I am using our sandbox trying to add a new account. I am using the login url :-

https://test.salesforce.com/services/Soap/u/23.0

and I am recieving a sessionid and server url.  My xml is :-

<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:partner.soap.sforce.com"> xmlns:urn1="urn:sobject.partner.soap.sforce.com"<soapenv:Header>

<urn:SessionHeader><urn:sessionId>00DV00000001NTA!AQkAQDz0VjxDeNk5jooMbhTF54n0JK8NrHDS3Jxr0ULivg63HxdeWuQZPz9UQqzCEos16Fo_47Yf3FupCwpx1nxuQDUoynyS</urn:sessionId></urn:SessionHeader></soapenv:Header><soapenv:Body>

<urn:sObjects>

<urn1:type>Account</urn1:type>

<RecordTypeId>01280000000FpbW</RecordTypeId>

<Optimus_User_ID__c>419842</Optimus_User_ID__c>

<Optimus_Partner__c></Optimus_Partner__c>

<User_Flag__c>normal</User_Flag__c>

<User_Status__c>active</User_Status__c>

<Link_to_Optimus_User_Record__C>https://vvvvvvvvvvvvvvv.com/optimus/set_myuser.php?yuser_id=419842&nextURL=userDetails.php</Link_to_Optimus_User_Record__C>

<Username__c>xxxx8@ymail.com</Username__c>

<Initiating_Media__c>none</Initiating_Media__c>

<FirstName>nnnn</FirstName>

<LastName>nnn</LastName>

<Phone></Phone>

<Type>Customer</Type>

<PersonEmail>pbbbbbb8@ymail.com</PersonEmail

><BillingStreet>31/25 HHT P.13 TAN BINH </BillingStreet>

<BillingCity>HCM</BillingCity>

<BillingPostalCode>0084</BillingPostalCode>

<BillingState>TB</BillingState>

<BillingCountry>USA</BillingCountry>

</urn:sObjects>

</soapenv:Body></soapenv:Envelope>

I have tried to follow the SOAP examples in the developer forum.

But I am getting the error :-

No operation available for request {urn:partner.soap.sforce.com}

If I use the enterprise login url , I do not get a session or server url returned so I believe I am using the correct login.

Any help would be great.

Hi,

I am relatively new to the API. I am send a request using an XML file I have created using Pentaho.

I am getting the error - 'SOAPAction HTTP header missing'

How do you specify a SOAPaction if you are not using a web page to access the API?

My sample XML :-

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:partner.soap.sforce.com"><soapenv:Header><urn:SessionHeader><urn:sessionId><b>00D80000000dSyn!AQIAQGjxY1K2T3lPrUqxAYjvS5anpICytsIM9SAfipbbuLP9jYP2pXFbVfkceI6YgnuPrLjj8EJhb5E8MSIGtHGUcg3Knwkn</b></urn:sessionId></urn:SessionHeader></soapenv:Header><soapenv:Body><urn:fieldList><b>Id, RecordTypeId</b></urn:fieldList><urn:sObjectType><b>Account</b></urn:sObjectType>

<urn:Optimus_User_ID__c><b>140946</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144402</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144404</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144406</b></urn:Optimus_User_ID__c>

</urn:retrieve></soapenv:Body></soapenv:Envelope>

Any help would be great - Just point me in the right direction!

Thanks in advance.

Hi,

I am using curl to query and return many rows from a table. I am getting a curl return code of 18 which says that the size of the file expected was not the same as was recieved.

If I add a LIMIT 10 to the (SOQL) query then it runs fine and I get a results file.

I know I will have to use querymore after the initial call but I need to get the query locator.

I have googled but not been able to find a resolution to this issue - Can anyone help?

Thanks,

Hi,

I am trying to use the API to get deleted tasks.

I initiate the request :-

<?xml version="1.0" encoding="UTF-8"?>

<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">

<operation>getDeleted</operation>

<contentType>XML</contentType>

</jobInfo>

And then try to create a request :-

<?xml version=\"1.0\" encoding=\"utf-8\"?>

<sObjects xmlns=\"http://www.force.com/2009/06/asyncapi/dataload\">

<sObjectType>Task</sObjectType>

<startDate>2011-12-31 00:00:00</startDate>

<endDate>2012-01-04 00:00:00</endDate>

</sObjects>

but it seems 'getDeleted' nor 'getdeleted' works. I have tried different combinations of post I have found in the forum without luck. :-(. I am not sure if I need the asyncapi/dataload to get deleted tasks?

Can someone direct me in the right direction?

Hi,

I am trying to return a list of deleted tasks via the bulk API but only seem to get one row returned.

My query :-

SELECT Id, IsDeleted from Task where IsDeleted=true

I have tried the 'queryall' option when initiating the job but get an error.

Ny job init :-

<?xml version="1.0" encoding="UTF-8"?>

<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">

<operation>query</operation>

<object>Task</object>

<concurrencyMode>Parallel</concurrencyMode>

<contentType>XML</contentType>

</jobInfo>

Do I have to specify a date range?

Thanks,

All,

I am using the Bulk Data Api to upsert a large number of records.  If one of those records fails I would not like the successful changes commited.  Is there a way to achieve this.  On the BulkConnection I see there is an abortJob method.  If I abort a job after it has already run through a few batchs will be undo the changes that have already been made?  Is there any easier way to do this?  Thanks in advance for any help. 

Hi,

I am relatively new to the API. I am send a request using an XML file I have created using Pentaho.

I am getting the error - 'SOAPAction HTTP header missing'

How do you specify a SOAPaction if you are not using a web page to access the API?

My sample XML :-

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:partner.soap.sforce.com"><soapenv:Header><urn:SessionHeader><urn:sessionId><b>00D80000000dSyn!AQIAQGjxY1K2T3lPrUqxAYjvS5anpICytsIM9SAfipbbuLP9jYP2pXFbVfkceI6YgnuPrLjj8EJhb5E8MSIGtHGUcg3Knwkn</b></urn:sessionId></urn:SessionHeader></soapenv:Header><soapenv:Body><urn:fieldList><b>Id, RecordTypeId</b></urn:fieldList><urn:sObjectType><b>Account</b></urn:sObjectType>

<urn:Optimus_User_ID__c><b>140946</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144402</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144404</b></urn:Optimus_User_ID__c>

<urn:Optimus_User_ID__c><b>144406</b></urn:Optimus_User_ID__c>

</urn:retrieve></soapenv:Body></soapenv:Envelope>

Any help would be great - Just point me in the right direction!

Thanks in advance.