{
  "openruna_format": "flow-graph-v1",
  "title": "0655_Code_Postgres_Update_Scheduled",
  "slug": "0655-code-postgres-update-scheduled",
  "source_filename": "0655_Code_Postgres_Update_Scheduled.json",
  "nodes": [
    {
      "id": "EXTRACT CAMPAIGN DATA",
      "name": "EXTRACT CAMPAIGN DATA",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "FETCH ALL CAMPAIGNS",
      "name": "FETCH ALL CAMPAIGNS",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Loop Over Items",
      "name": "Loop Over Items",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "UPDATE CAMPAIGN",
      "name": "UPDATE CAMPAIGN",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "Merge",
      "name": "Merge",
      "integration": "merge",
      "kind": "logic"
    },
    {
      "id": "Code",
      "name": "Code",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Loop Over Items1",
      "name": "Loop Over Items1",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "HubSpot",
      "name": "HubSpot",
      "integration": "hubspot",
      "kind": "action"
    },
    {
      "id": "If",
      "name": "If",
      "integration": "if",
      "kind": "logic"
    },
    {
      "id": "Schedule Trigger",
      "name": "Schedule Trigger",
      "integration": "schedule",
      "kind": "trigger"
    },
    {
      "id": "UPSERT CAMPAIGN ACTIVITY",
      "name": "UPSERT CAMPAIGN ACTIVITY",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "HUBSPOT TABLE",
      "name": "HUBSPOT TABLE",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "SEARCH",
      "name": "SEARCH",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "Postgres1",
      "name": "Postgres1",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "UPDATE HUBSPOT ACTIVITY TABLE",
      "name": "UPDATE HUBSPOT ACTIVITY TABLE",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "SET SMARTLEAD API KEY",
      "name": "SET SMARTLEAD API KEY",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Postgres",
      "name": "Postgres",
      "integration": "postgres",
      "kind": "action"
    },
    {
      "id": "Google Sheets",
      "name": "Google Sheets",
      "integration": "googleSheets",
      "kind": "action"
    }
  ],
  "edges": [
    {
      "from": "If",
      "to": "HUBSPOT TABLE"
    },
    {
      "from": "If",
      "to": "Postgres1"
    },
    {
      "from": "Code",
      "to": "UPSERT CAMPAIGN ACTIVITY"
    },
    {
      "from": "Merge",
      "to": "Loop Over Items"
    },
    {
      "from": "SEARCH",
      "to": "Loop Over Items1"
    },
    {
      "from": "HubSpot",
      "to": "If"
    },
    {
      "from": "Postgres",
      "to": "Google Sheets"
    },
    {
      "from": "Postgres1",
      "to": "Loop Over Items1"
    },
    {
      "from": "HUBSPOT TABLE",
      "to": "UPDATE HUBSPOT ACTIVITY TABLE"
    },
    {
      "from": "Loop Over Items",
      "to": "EXTRACT CAMPAIGN DATA"
    },
    {
      "from": "Loop Over Items",
      "to": "UPDATE CAMPAIGN"
    },
    {
      "from": "UPDATE CAMPAIGN",
      "to": "Merge"
    },
    {
      "from": "Loop Over Items1",
      "to": "HubSpot"
    },
    {
      "from": "Schedule Trigger",
      "to": "SET SMARTLEAD API KEY"
    },
    {
      "from": "FETCH ALL CAMPAIGNS",
      "to": "Loop Over Items"
    },
    {
      "from": "EXTRACT CAMPAIGN DATA",
      "to": "Code"
    },
    {
      "from": "SET SMARTLEAD API KEY",
      "to": "FETCH ALL CAMPAIGNS"
    },
    {
      "from": "SET SMARTLEAD API KEY",
      "to": "Postgres"
    },
    {
      "from": "SET SMARTLEAD API KEY",
      "to": "SEARCH"
    },
    {
      "from": "UPSERT CAMPAIGN ACTIVITY",
      "to": "Merge"
    },
    {
      "from": "UPSERT CAMPAIGN ACTIVITY",
      "to": "Merge"
    },
    {
      "from": "UPDATE HUBSPOT ACTIVITY TABLE",
      "to": "Loop Over Items1"
    }
  ]
}