• john yungk
  • NEWBIE
  • 50 Points
  • Member since 2012
  • architect
  • aetna


  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 28
    Replies
I have created an 30 days trial account today and was trying to connect to salesforce using API.
I am getting following exception. But in SalesForce Logn history it was success. Not sure what is happening. Please assist.
API Type: SOAP partner
Api Version: 30.0
Login Type: Other Apex API

API_DISABLED_FOR_ORG: API is not enabled for this Organization or Partner

Srini
Is there a known pattern for implementing optimistic locking from within an Apex class using DML?

Using Martin Fowler's Optimistic Offline Lock pattern as a starting point, it would seem to me that the update command would have be able to support a where clause, but I don't see that as an option with DML.

I might be missing something important as I am admitedly a newbie.

Thanks in advance.
John
In Chapter 7, section Org-Wide Defaults in our Recruiting App it states the following:

We want to allow hiring managers to view all employment website and job posting records without being able to edit them, so the answer to the second question is “No” while the answer to the third question is “Yes;” therefore, the sharing model for the Employment Website and Job Posting objects should be Public Read-Only.

Job Posting is defined for Hiring Manager as follows: Read* Create* Edit*
*Only for those records that are associated with a position to which the hiring manager/interviewer has been assigned.

My question is, should the sharing model for Job Posting really be set to PUBLIC READ-ONLY or should it be set to PRIVATE because the there is an instance where the user shouldn't be able to view a record. Again, per the book, Hiring Managers are limited to those records that are associated with a position to which they have been assigned.

Perhaps I'm mis-understanding.

Thanks,
John

Hi,

 

I've encountered a problem while using outbound messages that contain a semicolon (";") in text attributes. Salesforce appears to substitute the ";" for ";" as in the following sample:

 

<sf:Text__c>This is a test&semi; a test of semicolons</sf:Text__c>

 

The messages are processed by custom Java code that extracts the sObject nodes using javax.xml.xpath classes. XPath reports the following error:

 

org.xml.sax.SAXParseException: The entity "semi" was referenced, but not declared.
Exception in thread "main" java.lang.NullPointerException
 at com.test.TestNotificationsParsing.main(TestNotificationsParsing.java:39) 

 

I believe "&semi;" is not standard XML, so prior to processing the outbound message, code was added to search for "&semi" and substitute the ";" back in.

 

Question: Does anyone know why Salesforce may be doing the ";" to "&semi;" substitution?

 

Thanks,

John

Hi Community- my BI Team has run into issues retreiving soft-deleted records (IsDeleted = TRUE) from the AccountContactRelation Object when using the Bulk API.  When retrieving Salesforce records using SOAP, they are indeed able to retrieve the soft-deleted record(s).

Is this simply a limitation of the Bulk API?

Thank you in advance for your feedback!
Hi,

I need help in reading/storing and parsing big (~70-80 MB) XML file.

1] As per our requirement, the third party system will upload the xml on secure ftp, which we will need to bring in Salesforce.
I know Salesforce doesn't support FTP natively, I amy need to introduce a java/dotnet app in between or go for third party solutions like Jittebit or dataloader.io.

2] This xml will contain 2000-3000 records, each with approx 150 fields. We will need to prse this big xml, and upsert these records.
I have used Apex DOM to parse xmls in Salesforce, but not sure it will be the appropriate for our requirement.

​Any recommended appraoches for these requirements?

Thanks,
  • February 26, 2016
  • Like
  • 0
Senario 1: Accounts, Contact, Products, and a Custom Bbject records are created, updated, or deleted in Salesforce. Any of these changes need to be synced to an external system (that can recieve or send SOAP API messages) to keep the external system updated with the latest changes in Salesforce. These records will be read-only in the external system so this will be a one-way integration from Salesforce to the external system. Which of these option are the most effiecint way to avoid hitting the limits and efficient future maintenance:

1- Outbound Message action on a Workflow
2- Future Apex trigger on each object
3- Scheduled Apex Class to run in time intervals

Senario 2: Case and Order records (including Order Products) are created in Saleforce. Any new record should be sent to the external system. After the record created in the external system, any update will only be allowed in the external system and will be read-only in Salesforce. Therefore, any changes done in the external system should be synced back in a real-time or near real-time manner to Salesforce to show the most current status of the Order and Case in Salesforce. Which of the above the most efficient way fir this senario.

Any help is greatly appreciated.
Hi All,

I am facing this wierd issue where I am trying to run a Bulk API java program. When I tested this program in a sandbox, I was getting success response and results. However, when we moved this to our production, I am getting below error:

[AsyncApiException  exceptionCode='UnsupportedContentType'

 exceptionMessage='Unsupported content type: text/xml'

]

I traced back the error to the Create or update job method of Bulk connection 

Could you let me know what am I missing here.
Hi,

We started receiving an exception while trying to invoke the Bulk API to create a job in our Sandbox.  We haven't had any issues before until now.  Our code is unchanged since the last time we touched it.  I was able to capture the request as well as the response.  The call to the SOAP service to log in works fine and returns a sessionID, but when we build the request to create a job it returns the 400 Bad Request response.  Once I stream the response out to get the details I get the following:

  <?xml version="1.0" encoding="UTF-8"?><error
   xmlns="http://www.force.com/2009/06/asyncapi/dataload">
 <exceptionCode>Unknown</exceptionCode>
 <exceptionMessage>Unknown exception in Async API. Please contact support with ID: 1190435897-34246 (361211693)</exceptionMessage>
</error>

Here is the request string we submit, nothing has changed here:
<?xml version="1.0" encoding="UTF-8"?>
    <jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">
        <operation>query</operation>
        <object>Account</object>
               
        <contentType>CSV</contentType>
    </jobInfo>

I've verified the endpoint that it is hitting as well, nothing has changed here either.
https://cs9-api.salesforce.com/services/async/31.0/job

I've checked permissions on the Salesforce objects to verify select access, I've tried a couple of different user credentials in place of our API user that we set up with no luck.  Any help would be appreciated.
Hi everyone,

Could you guyz help me give idea about - how to do integration of two or more salesforce application

Thanks in advance
As im new to salesforce, i would like to know, how all we can start customize or integrate salesforce to a .Net Application.
Do sales force have API`s? Is Salesforce capable of calling other API calls and fetch data..

Any help in above stuffs are always welcomed.

Thanks
Althaf
I am using the bulk API to fetch leads from Salesforce. The SObject Lead has, among others, the default field Fax and MobilePhone. However, the following query fails:
SELECT Name,Fax,MobilePhone FROM Lead
with the following error:
[Error: InvalidBatch : Failed to process query: INVALID_FIELD:  SELECT Name,Fax FROM Lead             ^ ERROR at Row:1:Column:13 No such column 'Fax' on entity 'Lead'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.]
Why can't i query these fields although they appear as standard fields under Customize -> Leads -> Fields?

 
I have created an 30 days trial account today and was trying to connect to salesforce using API.
I am getting following exception. But in SalesForce Logn history it was success. Not sure what is happening. Please assist.
API Type: SOAP partner
Api Version: 30.0
Login Type: Other Apex API

API_DISABLED_FOR_ORG: API is not enabled for this Organization or Partner

Srini
Hi everyone,

it is possible to retrieve query results trough BULK API as an xml document. However there seems no chance to get a corresponding schema definition (xsd), which is likely to be required for integrations with other systems.

I'm thankful for any ideas!
Hello,

I have an integration requirement where an external SFDC application to going to send me outbound messages which I need to read and process in my SFDC application.
I am wondering how can I read the outbound messages? Can I write Apex webservice? Will that work?
When huge number of data is synced from offline to online does it synced one by one/several  data at a time?
  • August 08, 2015
  • Like
  • 0