MatthewJBloom

URL:
https://api.infusionsoft.com/crm/xmlrpc/v1?access_token=<REDACTED>

BODY:
<?xml version="1.0"?>
<methodCall>
    <methodName>DataService.update</methodName>
    <params>
        <param>
            <value>

MatthewJBloom

6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/9f0b9166-88f8-11e9-b9db-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b7f5958e-885b-11e9-ac59-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b80b90ce-8927-11e9-9bc4-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b82c2062-88ac-11e9-a22d-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b914e0f6-885a-11e9-9bd4-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b97bc8fe-888a-11e9-8dfb-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/b9b8ed26-8928-11e9-9f49-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/bb611306-885b-11e9-a6cc-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/bcbafcd6-885a-11e9-ae92-021be36d3554
6 5ea85745501bbc06005cde99 CACHE CREATE sugarcrm0/account/bcdc8a6a-888a-11e9-86f7-021be36d3554

MatthewJBloom

select Id, IsDeleted, MasterRecordId, LastName, FirstName, Salutation, Name, RecordTypeId, Title, Company, Street, City, State, PostalCode, Country, Latitude, Longitude, Address, Phone, MobilePhone, Fax, Email, Website, PhotoUrl, Description, LeadSource, Status, Industry, CurrencyIsoCode, OwnerId, HasOptedOutOfEmail, IsConverted, ConvertedDate, ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId, IsUnreadByOwner, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastActivityDate, LastViewedDate, LastReferencedDate, Jigsaw, JigsawContactId, ConnectionReceivedId, ConnectionSentId, EmailBouncedReason, EmailBouncedDate, ProductsInterest__c, AdditionalComments__c, CTA__c, Channel__c, FormID__c, Solution_Family__c, Solution__c, CurrentSoftware__c, Tier__c, VerticalMarket__c, rrpu__Alert_Message__c, Software_Advice_Notes__c, No_Outreaches_since_LFFD__c, SalesLoft_Stage__c, Unqualified_Reason_2__c, Time_to_First_Follow_Up__c, Web_Form__c, ON24EventTitle__c, LastOutreachByRole__c

MatthewJBloom

[
  {
    "customer": "Mews",
    "customer id": "5d10e6c879276e3026443bbd",
    "object": "company",
    "targets": {
      "hubspot0": "properties/pipedrive_id",
      "pipedrive0": "idString"
    }
  },

MatthewJBloom

{
    "dataType" : "account",
    "fields" : "nov_portefeuilles_id,nov_naf_id,nov_segment_id,nov_secteur_id,nov_enseigne_id",
    "expandExpressions" : {
        "nov_portefeuilles_id" : "nov_portefeuilles_id($select=nov_libelle,nov_portefeuillesid)",
        "nov_naf_id" : "nov_naf_id($select=nov_libelle,nov_nafid)",
        "nov_segment_id" : "nov_segment_id($select=nov_libelle,nov_segmentid)",
        "nov_secteur_id" : "nov_secteur_id($select=nov_libelle,nov_secteurid)",
        "nov_enseigne_id" : "nov_enseigne_id($select=nov_nom,nov_enseigneid)"
    },

MatthewJBloom

[
  {
    "customer_id": "5cd2ead33a66f988513c604f",
    "customer_name": "CTS",
    "object_name": "opportunity",
    "goal": "replace close_date with create_date in dedupe key"
  },
  {
    "targets": {
      "autotask1": "opportunity/fields/CREATEDATE",

MatthewJBloom

[
  {
    "customer": "5e2f11056ac61c0576bf4693",
    "patch": "dedupe key patch for opportunities",
    "targets": {
      "connectwise": "opportunity/fields/ID",
      "hubspot": "deal/fields/CW_OPPORTUNITY_ID"
    }
  },
  {

MatthewJBloom

<?xml version='1.0' encoding='UTF-8'?>
<methodCall>
  <methodName>DataService.query</methodName>
  <params>
    <param>
      <value><string></string></value>
    </param>
    <param>
      <value><string>DataFormField</string></value>
    </param>

MatthewJBloom

{
  "5e2f11056ac61c0576bf4693 Avertium": "dedupe key swap for companies",
  "targets": {
    "hubspot": {
      "Company ID": "properties/hs_object_id"
    },
    "connectwise": {
      "Hubspot Company ID": "customFields/107"
    }
  },

MatthewJBloom

{
  "goal": "dedupe key swap from opp/close_date to opp/first_appointment_date",
  "targets": {
    "dynamics": "bdo_firstappointment",
    "hubspot": "properties/hs_date_entered_appointmentscheduled"
  },
  "dynamics patches": [
    {
      "path": "opportunity/fields/CLOSE_DATE",
      "value": {