Hi all - Working on connecting our back end and HubSpot using the HubSpot + cdata integration but running into some roadblocks. We have been able to upload a single company and single contact but are finding the following issues below:
Inserting a company record and attaching the sales rep [I assume that is the Hubspot Owner field]. It appears to be a numeric (real) value. How can I get a list of all existing owners so I can attach the correct value when I insert the record?
Creating contacts, same thing, want to add the sales rep (assume its the Hubspot Owner field). When I try to add a second contact, it fails, so I am not sure what I need to include in my insert statement (using cdata HubSpot control) to add more than 1 contact per company.
We haven't gotten to pulling in prior deals yet but suspect we will run into a similar issue.
Thank you for any assistance possible. Until we can fix this...we are dead in the water!