{
  "openruna_format": "flow-graph-v1",
  "title": "Import Productboard Notes, Companies and Features into Snowflake",
  "slug": "import-productboard-notes-companies-and-features-into-snowflake",
  "source_filename": "0643_Splitout_Snowflake_Import_Scheduled.json",
  "nodes": [
    {
      "id": "Manual mapping feature",
      "name": "Manual mapping feature",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "get productboard companies",
      "name": "get productboard companies",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Manual mapping companies",
      "name": "Manual mapping companies",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "get productboard notes",
      "name": "get productboard notes",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Manual mapping notes",
      "name": "Manual mapping notes",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Split features",
      "name": "Split features",
      "integration": "splitOut",
      "kind": "logic"
    },
    {
      "id": "Split companies",
      "name": "Split companies",
      "integration": "splitOut",
      "kind": "logic"
    },
    {
      "id": "Split notes",
      "name": "Split notes",
      "integration": "splitOut",
      "kind": "logic"
    },
    {
      "id": "Split features in notes",
      "name": "Split features in notes",
      "integration": "splitOut",
      "kind": "logic"
    },
    {
      "id": "Combine Feature ID + Note ID",
      "name": "Combine Feature ID + Note ID",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "get productboard features",
      "name": "get productboard features",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Update Productboard Notes",
      "name": "Update Productboard Notes",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Empty Table Productboard Notes",
      "name": "Empty Table Productboard Notes",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "[CREATE] PRODUCTBOARD_NOTES",
      "name": "[CREATE] PRODUCTBOARD_NOTES",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "[CREATE] PRODUCTBOARD_COMPANIES",
      "name": "[CREATE] PRODUCTBOARD_COMPANIES",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Update Productboard Companies",
      "name": "Update Productboard Companies",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Manual mapping companies db",
      "name": "Manual mapping companies db",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Manual mapping notes db",
      "name": "Manual mapping notes db",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Empty Table Productboard Companies",
      "name": "Empty Table Productboard Companies",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "[CREATE] PRODUCTBOARD_NOTES_FEATURES",
      "name": "[CREATE] PRODUCTBOARD_NOTES_FEATURES",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Manual mapping feature note IDs db",
      "name": "Manual mapping feature note IDs db",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Update Productboard Note and Feature IDs",
      "name": "Update Productboard Note and Feature IDs",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Empty Table Productboard Note and Feature IDs",
      "name": "Empty Table Productboard Note and Feature IDs",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Loop Over Items notes",
      "name": "Loop Over Items notes",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "Loop Over Items features notes",
      "name": "Loop Over Items features notes",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "[CREATE] PRODUCTBOARD_FEATURES",
      "name": "[CREATE] PRODUCTBOARD_FEATURES",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Empty Table Productboard Features",
      "name": "Empty Table Productboard Features",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Loop Over Items features",
      "name": "Loop Over Items features",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "Manual mapping features db",
      "name": "Manual mapping features db",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Update Productboard Features",
      "name": "Update Productboard Features",
      "integration": "snowflake",
      "kind": "action"
    },
    {
      "id": "Schedule Trigger",
      "name": "Schedule Trigger",
      "integration": "schedule",
      "kind": "trigger"
    },
    {
      "id": "Slack",
      "name": "Slack",
      "integration": "slack",
      "kind": "action"
    },
    {
      "id": "Count Notes Last 7 days and Unprocessed",
      "name": "Count Notes Last 7 days and Unprocessed",
      "integration": "snowflake",
      "kind": "action"
    }
  ],
  "edges": [
    {
      "from": "Split notes",
      "to": "Manual mapping notes"
    },
    {
      "from": "Split notes",
      "to": "Split features in notes"
    },
    {
      "from": "Split notes",
      "to": "Count Notes Last 7 days and Unprocessed"
    },
    {
      "from": "Split features",
      "to": "Manual mapping feature"
    },
    {
      "from": "Split companies",
      "to": "Manual mapping companies"
    },
    {
      "from": "Schedule Trigger",
      "to": "Empty Table Productboard Features"
    },
    {
      "from": "Manual mapping notes",
      "to": "Loop Over Items notes"
    },
    {
      "from": "Loop Over Items notes",
      "to": "Manual mapping notes db"
    },
    {
      "from": "Manual mapping feature",
      "to": "Loop Over Items features"
    },
    {
      "from": "get productboard notes",
      "to": "Split notes"
    },
    {
      "from": "Manual mapping notes db",
      "to": "Update Productboard Notes"
    },
    {
      "from": "Split features in notes",
      "to": "Combine Feature ID + Note ID"
    },
    {
      "from": "Loop Over Items features",
      "to": "Empty Table Productboard Companies"
    },
    {
      "from": "Loop Over Items features",
      "to": "Manual mapping features db"
    },
    {
      "from": "Manual mapping companies",
      "to": "Manual mapping companies db"
    },
    {
      "from": "Update Productboard Notes",
      "to": "Loop Over Items notes"
    },
    {
      "from": "get productboard features",
      "to": "Split features"
    },
    {
      "from": "Manual mapping features db",
      "to": "Update Productboard Features"
    },
    {
      "from": "get productboard companies",
      "to": "Split companies"
    },
    {
      "from": "Manual mapping companies db",
      "to": "Update Productboard Companies"
    },
    {
      "from": "Combine Feature ID + Note ID",
      "to": "Loop Over Items features notes"
    },
    {
      "from": "Update Productboard Features",
      "to": "Loop Over Items features"
    },
    {
      "from": "Update Productboard Companies",
      "to": "Empty Table Productboard Note and Feature IDs"
    },
    {
      "from": "Empty Table Productboard Notes",
      "to": "get productboard notes"
    },
    {
      "from": "Loop Over Items features notes",
      "to": "Manual mapping feature note IDs db"
    },
    {
      "from": "Empty Table Productboard Features",
      "to": "get productboard features"
    },
    {
      "from": "Empty Table Productboard Companies",
      "to": "get productboard companies"
    },
    {
      "from": "Manual mapping feature note IDs db",
      "to": "Update Productboard Note and Feature IDs"
    },
    {
      "from": "Count Notes Last 7 days and Unprocessed",
      "to": "Slack"
    },
    {
      "from": "Update Productboard Note and Feature IDs",
      "to": "Loop Over Items features notes"
    },
    {
      "from": "Empty Table Productboard Note and Feature IDs",
      "to": "Empty Table Productboard Notes"
    }
  ]
}