Fresh Sales CRM connector not bringing in key contact data

  • 225Views
  • Last Post 26 October 2022
0
votes
Sharmila Vanukuru posted this 25 October 2022

The FreshSales CRM connector and the query tool against the CONTACT table- 2 key fields are not returning the data in the query: CONTACT.ContactStatusId and CONTACT.LifecycleStageId. The data exists in the source but the query tool is returnign blank/null. This is a Big issue as we need a contact's current status and stage it is in its sales life cycle. 

SQL: 

Select t.FirstName, t.LastName, t.Email,  t.MobileNumber, t.LastContactedMode, t.LastContacted, t.LastContactedSalesActivityMode, t.CustomField,

t.Keyword, t.Medium, t.LastContactedViaSalesActivity, t.CompletedSalesSequences, t.ActiveSalesSequences, t.LastAssignedAt, t.Tags, t.IsDeleted, t.TeamUserIds, t.LifecycleStageId, t.TerritoryId, t.OwnerId, t.ContactStatusId, t.SalesAccountId,  t.CreatedDate, t.UpdatedDate, z.name as Location , q.name as territory, c.name as lifecyclestatus, p.name as lifecyclestage

From contacts as t, accounts  as z

, Territories as q, contactstatuses as c,  LifecycleStages AS p

Where z.id= t.SalesAccountId And q.id = t.territoryid

 And c.id= t.ContactStatusId and p.id= t.LifecycleStageId

0
votes
Yevheniia Bilotserkovska posted this 26 October 2022

Hello Sharmila.

Thank you for contacting us.

We will reply to you via email as soon as possible. Please check your mailbox.

Best regards,

Yevheniia Bilotserkovska.

Close