change in behavior when querying SalesForce data with Advanced ETL Processor

More
7 years 2 months ago - 7 years 2 months ago #15492 by dmart024
I just upgraded to version 5.9.2.12 of Advanced ELT Processor Enterprise Edition (32 bit). The query that I run against the SFDC (SalesForce) account object returns different results now. Instead of returning the individual owner fields (name, isactive, id, and id), the owner fields come back in what I assume is a JSON representation of the owner object. The owner data that appears in Advanced ETL Processor looks like this:

{attributes:{type:User,url:/services/data/v32.0/sobjects/User/00580000003u7nOAAQ},Name:Andrew Lopez,IsActive:true,Id:00580000003u7nOAAQ}

I'd like to have these fields expressed individually like they were in previous editions of the software.

Here is the query that I'm using:

SELECT Id, Name, Type, ParentId, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, Phone, Fax, Activation_Code__c, Class__c, Num_Schools__c, SLICK_Legacy_ID__c, Sales_Channel__c, Seed_or_Expansion_Indicator__c, Status__c, Territory_Type__c, Region__c, Cluster__c, Tenant_Account__c, Manager_Contact__c, PSPM_Billing_Account_Org_ID__c, PSPM_Billing_Account__c, PSPM_Billing__c, support_end_date__c, owner.name, owner.isactive, owner.id, ispersonaccount, p_id__c,
Website, County__c, State_Province__c, tier__c, pstreet__c, pcity__c,
pstate__c, pzipcode__c, last_mdr_data_file_date__c, last_mdr_update__c,
mdr_institution_name__c, mdrurl__c, mdrphone__c, mcounty__c, slick_parent_id__c,
spec_ed__c
FROM Account WHERE isdeleted=false limit 100

Thanks
Don Martin
Last edit: 7 years 2 months ago by dmart024. Reason: spelling

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15493 by Peter.Jonson
Thank you for the feedback.
On of our developers will have a look at it for you

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15510 by dmart024
Thank you for following up with my request. It's important that it gets fixed as my current SalesForce integrations no longer work.

Don Martin

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15511 by admin
Hello

The problem you reported was addressed in the latest release


SalesForce is very tricky to work with
We do recommend testing the rest of import to make sure that the work as expected

Mike
ETL Architect
Attachments:
The following user(s) said Thank You: dmart024

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15516 by dmart024
Thank you for the quick turnaround Mike. I'll let you know if I run into any problems with the new version.

Don Martin

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago - 6 years 10 months ago #15936 by Peter.Jonson
Hi Don.

Just letting you know that we have made some changes to extracting data from sales force.
and we want to make sure that it works as expected for you.
Please test latest version and let us know the outcome

Peter Jonson
ETL Developer
Last edit: 6 years 10 months ago by Peter.Jonson.
The following user(s) said Thank You: dmart024

Please Log in or Create an account to join the conversation.