Fresh Sales CRM connector not bringing in key contact data

  • 241Views
  • Last Post 26 October 2022
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. 


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, as Location , as territory, as lifecyclestatus, as lifecyclestage

From contacts as t, accounts  as z

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

Where t.SalesAccountId And = t.territoryid

 And t.ContactStatusId and t.LifecycleStageId

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.