Hi,

I am getting following error while performing an 'Update' on a record of Group object using Bulk v2 API

"","INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY:insufficient access rights on cross-reference id:--","00G2w000002rN1dEAE","","CEOA","","false","true"

I am currently authenticated using a user having System Administrator role. I believe as a system administrator I have sufficient privilege. Is there something I am missing here ?

Regards,
Suhel

 

Hi,

Using Sample data provided with developer edition, I deleted all the Leads and then tried to re-insert them again. What I find is all the Leads get successfully inserted using Bulk v2 API, except for the following three. It fails with an error saying DUPLICATED DETECTED. I checked my portal again and find that none of these Leads already exist. Any guesses why I am getting this error for these 3 Leads when rest 19 (There are in all 19 + 3 = 22 Leads)


"sf__Id","sf__Error","LastName","FirstName","Salutation","Title","Company","Street","City","State","PostalCode","Country","Latitude","Longitude","GeocodeAccuracy","Phone","MobilePhone","Fax","Email","Website","Description","LeadSource","Status","Industry","Rating","AnnualRevenue","NumberOfEmployees","OwnerId","IsConverted","ConvertedDate","ConvertedAccountId","ConvertedContactId","ConvertedOpportunityId","IsUnreadByOwner","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","Jigsaw","CleanStatus","CompanyDunsNumber","DandbCompanyId","IndividualId","SICCode__c","ProductInterest__c","Primary__c","CurrentGenerators__c","NumberofLocations__c"
"","DUPLICATES_DETECTED:Use one of these records?:--","Stumuller","Pat","Ms","SVP, Administration and Finance","Pyramid Construction Inc.","","","","","France","","","","33562156600","","","pat@pyramid.net","","","Phone Inquiry","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Young","Andy","Mr","SVP, Operations","Dickenson plc","","","KS","","USA","","","","(620) 241-6200","","","a_young@dickenson.com","","","Purchased List","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Rogers","Jack","Mr.","VP, Facilities","Burlington Textiles Corp of America","525 S. Lexington Ave","Burlington","NC","27215","USA","","","","(336) 222-7000","","(336) 222-8000","jrogers@btca.com","","","Web","Closed - Converted","Apparel","Warm","3.5E8","9000","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","7267","GC5000 series","Yes","John Deere","3.0"

Regards,
Suhel
 

Hi,

Documentation here suggests that Bulk v2 API can use relationship field in header, 

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/relationship_fields_in_a_header_row__2_0.htm

But, I am also able to Ingest records of Child object without specifiying relationship (but by just specifying field name of the child Object). Then what is the need for specifying the foreign key field using relationship in header ? Am I missing something here ?

Thanks,
Suhel

 

Hi,

I see that after signing up for Partner edition (I've done a free sign-up), I get to create following Orgs from Environment Hub:

- Patner Enterprise
- Enterprise
- Sales Enterprise

I would however like to test my App for Unlimited edition too. But its not available in Environment Hub. How can I possibly get my App tested for Unlimited edition ?

Thanks,
Suhel

Hi,

1) I vaguely understand from the docs that it is possible to add ExternalId to majority of Standard objects. But still I would like to confirm.

2) https://help.salesforce.com/articleView?id=adding_fields.htm&type=0 suggests that only 800 Custom fields (My externalId field on an object will be budgeted against this limit I believe) can exist in an Org. These can be consumed by Custom Apps already installed in the Org as they create a lot of custom objects. Can someone confirm if there is truly such a limitation ?

Thanks,
Suhel

Salesforce has many relationship types. This reference (https://developer.salesforce.com/forums/?id=906F0000000913hIAA) suggests that circular dependency will not be supported for Records within same Object. However, self-relationships as documented here (https://help.salesforce.com/articleView?id=sf.relationships_considerations.htm&type=5) suggests that it is possible. So the question is, is such circular dependency possible ? Also, is circular dependency possible across Records of different Objects (especially with Custom Objects) ?

I have created and updated a few Contacts and have also encoded start and end parameters
Following is my REST call
GET https://xxx.xxx.xxx/services/data/v49.0/sobjects/Contact/updated?start=2020-11-01T00%3A00%3A00%2B05%3A30&end=2020-11-06T14%3A56%3A00%2B05%3A30

But I keep getting 
[
    {
        "errorCode": "NOT_FOUND",
        "message": "The requested resource does not exist"
    }
]
What am I missing here ?

Thanks
Suhel

 

Hi,

I am getting following error while performing an 'Update' on a record of Group object using Bulk v2 API

"","INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY:insufficient access rights on cross-reference id:--","00G2w000002rN1dEAE","","CEOA","","false","true"

I am currently authenticated using a user having System Administrator role. I believe as a system administrator I have sufficient privilege. Is there something I am missing here ?

Regards,
Suhel

 

Hi,

Using Sample data provided with developer edition, I deleted all the Leads and then tried to re-insert them again. What I find is all the Leads get successfully inserted using Bulk v2 API, except for the following three. It fails with an error saying DUPLICATED DETECTED. I checked my portal again and find that none of these Leads already exist. Any guesses why I am getting this error for these 3 Leads when rest 19 (There are in all 19 + 3 = 22 Leads)


"sf__Id","sf__Error","LastName","FirstName","Salutation","Title","Company","Street","City","State","PostalCode","Country","Latitude","Longitude","GeocodeAccuracy","Phone","MobilePhone","Fax","Email","Website","Description","LeadSource","Status","Industry","Rating","AnnualRevenue","NumberOfEmployees","OwnerId","IsConverted","ConvertedDate","ConvertedAccountId","ConvertedContactId","ConvertedOpportunityId","IsUnreadByOwner","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","Jigsaw","CleanStatus","CompanyDunsNumber","DandbCompanyId","IndividualId","SICCode__c","ProductInterest__c","Primary__c","CurrentGenerators__c","NumberofLocations__c"
"","DUPLICATES_DETECTED:Use one of these records?:--","Stumuller","Pat","Ms","SVP, Administration and Finance","Pyramid Construction Inc.","","","","","France","","","","33562156600","","","pat@pyramid.net","","","Phone Inquiry","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Young","Andy","Mr","SVP, Operations","Dickenson plc","","","KS","","USA","","","","(620) 241-6200","","","a_young@dickenson.com","","","Purchased List","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Rogers","Jack","Mr.","VP, Facilities","Burlington Textiles Corp of America","525 S. Lexington Ave","Burlington","NC","27215","USA","","","","(336) 222-7000","","(336) 222-8000","jrogers@btca.com","","","Web","Closed - Converted","Apparel","Warm","3.5E8","9000","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","7267","GC5000 series","Yes","John Deere","3.0"

Regards,
Suhel
 

Hi,

Documentation here suggests that Bulk v2 API can use relationship field in header, 

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/relationship_fields_in_a_header_row__2_0.htm

But, I am also able to Ingest records of Child object without specifiying relationship (but by just specifying field name of the child Object). Then what is the need for specifying the foreign key field using relationship in header ? Am I missing something here ?

Thanks,
Suhel

 

Hi,

I see that after signing up for Partner edition (I've done a free sign-up), I get to create following Orgs from Environment Hub:

- Patner Enterprise
- Enterprise
- Sales Enterprise

I would however like to test my App for Unlimited edition too. But its not available in Environment Hub. How can I possibly get my App tested for Unlimited edition ?

Thanks,
Suhel

Hi,

1) I vaguely understand from the docs that it is possible to add ExternalId to majority of Standard objects. But still I would like to confirm.

2) https://help.salesforce.com/articleView?id=adding_fields.htm&type=0 suggests that only 800 Custom fields (My externalId field on an object will be budgeted against this limit I believe) can exist in an Org. These can be consumed by Custom Apps already installed in the Org as they create a lot of custom objects. Can someone confirm if there is truly such a limitation ?

Thanks,
Suhel

Salesforce has many relationship types. This reference (https://developer.salesforce.com/forums/?id=906F0000000913hIAA) suggests that circular dependency will not be supported for Records within same Object. However, self-relationships as documented here (https://help.salesforce.com/articleView?id=sf.relationships_considerations.htm&type=5) suggests that it is possible. So the question is, is such circular dependency possible ? Also, is circular dependency possible across Records of different Objects (especially with Custom Objects) ?

I have created and updated a few Contacts and have also encoded start and end parameters
Following is my REST call
GET https://xxx.xxx.xxx/services/data/v49.0/sobjects/Contact/updated?start=2020-11-01T00%3A00%3A00%2B05%3A30&end=2020-11-06T14%3A56%3A00%2B05%3A30

But I keep getting 
[
    {
        "errorCode": "NOT_FOUND",
        "message": "The requested resource does not exist"
    }
]
What am I missing here ?

Thanks
Suhel

 

Hi,
Thanks in advance for any help and advice. So we are building a data integration using Bulk API v2, but now we have a big concern as to how we can match up the record ID's returned for insert operations to the records which were sent.

https://developer.salesforce.com/docs/atlas.en-us.api_bulk_v2.meta/api_bulk_v2/get_job_successful_results.htm

Usage Notes
The order of records in the response is not guaranteed to match the ordering of records in the original job data.

First, not sure when exactly the order is not guaranteed. If all records insert succesfully, the order does seem to match.

Second, when some records fail, then the order of course does not match, because the failed records are now in the failed results endpoint. 
So lets say you send in for insert:

Test account 1
Test account 2
Test account 3

And account 2 fails. then the success endpoint for bulk api v2 will return Test account 1 and Test account 3. The failure endpoint will return Test account 2. But there is no way to trace them to the original records we were inserting. how does Salesforce expect that to work?

With Bulk API v1 the results were returned in one list which matched up to the order of the records which were sent in, with the last containing both success and failure.

Is it possible to do this?