- Posts: 86
- Thank you received: 0
change in behavior when querying SalesForce data with Advanced ETL Processor
7 years 2 months ago - 7 years 2 months ago #15492
by dmart024
change in behavior when querying SalesForce data with Advanced ETL Processor was created 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
{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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
7 years 2 months ago #15493
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic change in behavior when querying SalesForce data with Advanced ETL Processor
Thank you for the feedback.
On of our developers will have a look at it for you
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.
7 years 2 months ago #15510
by dmart024
Replied by dmart024 on topic change in behavior when querying SalesForce data with Advanced ETL Processor
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
Don Martin
Please Log in or Create an account to join the conversation.
7 years 2 months ago #15511
by admin
Mike
ETL Architect
Replied by admin on topic change in behavior when querying SalesForce data with Advanced ETL Processor
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
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
The following user(s) said Thank You: dmart024
Please Log in or Create an account to join the conversation.
7 years 2 months ago #15516
by dmart024
Replied by dmart024 on topic change in behavior when querying SalesForce data with Advanced ETL Processor
Thank you for the quick turnaround Mike. I'll let you know if I run into any problems with the new version.
Don Martin
Don Martin
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
6 years 10 months ago - 6 years 10 months ago #15936
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic change in behavior when querying SalesForce data with Advanced ETL Processor
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
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.