Create a Data Diff Monitor

curl --request POST \
  --url https://app.datafold.com/api/v1/monitors/create/diff \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "datadiff": {
    "dataset_a": {
      "connection_id": 123,
      "table": "<string>",
      "filter": "<string>",
      "session_parameters": {},
      "time_travel_point": "<string>"
    },
    "dataset_b": {
      "connection_id": 123,
      "table": "<string>",
      "filter": "<string>",
      "session_parameters": {},
      "time_travel_point": "<string>"
    },
    "primary_key": [
      "<string>"
    ],
    "column_remapping": {},
    "columns_to_compare": [
      "<string>"
    ],
    "compare_duplicates": true,
    "exclude_columns": [
      "<string>"
    ],
    "ignore_string_case": false,
    "include_columns": [
      "<string>"
    ],
    "materialize_results": false,
    "null_equals_empty_string": false,
    "sampling": {
      "confidence": 123,
      "tolerance": 123,
      "threshold": 123
    },
    "sort_array_columns": true,
    "timeseries_dimension_column": "<string>",
    "tolerance": {
      "datetime": {},
      "float": {
        "column_tolerance": {},
        "default": {
          "value": 123,
          "type": "relative"
        }
      }
    }
  },
  "name": "<string>",
  "schedule": {
    "interval": {
      "every": "<string>",
      "type": "hourly"
    }
  },
  "alert": {
    "different_rows_count": 123,
    "different_rows_percent": 123,
    "match_ratio_min": 0.5
  },
  "description": "<string>",
  "enabled": true,
  "notifications": [
    {
      "recipients": [
        "<string>"
      ],
      "features": [],
      "type": "email"
    }
  ],
  "owner": "<string>",
  "tags": [
    "<string>"
  ]
}
'

import requests

url = "https://app.datafold.com/api/v1/monitors/create/diff"

payload = {
    "datadiff": {
        "dataset_a": {
            "connection_id": 123,
            "table": "<string>",
            "filter": "<string>",
            "session_parameters": {},
            "time_travel_point": "<string>"
        },
        "dataset_b": {
            "connection_id": 123,
            "table": "<string>",
            "filter": "<string>",
            "session_parameters": {},
            "time_travel_point": "<string>"
        },
        "primary_key": ["<string>"],
        "column_remapping": {},
        "columns_to_compare": ["<string>"],
        "compare_duplicates": True,
        "exclude_columns": ["<string>"],
        "ignore_string_case": False,
        "include_columns": ["<string>"],
        "materialize_results": False,
        "null_equals_empty_string": False,
        "sampling": {
            "confidence": 123,
            "tolerance": 123,
            "threshold": 123
        },
        "sort_array_columns": True,
        "timeseries_dimension_column": "<string>",
        "tolerance": {
            "datetime": {},
            "float": {
                "column_tolerance": {},
                "default": {
                    "value": 123,
                    "type": "relative"
                }
            }
        }
    },
    "name": "<string>",
    "schedule": { "interval": {
            "every": "<string>",
            "type": "hourly"
        } },
    "alert": {
        "different_rows_count": 123,
        "different_rows_percent": 123,
        "match_ratio_min": 0.5
    },
    "description": "<string>",
    "enabled": True,
    "notifications": [
        {
            "recipients": ["<string>"],
            "features": [],
            "type": "email"
        }
    ],
    "owner": "<string>",
    "tags": ["<string>"]
}
headers = {
    "Authorization": "<api-key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    datadiff: {
      dataset_a: {
        connection_id: 123,
        table: '<string>',
        filter: '<string>',
        session_parameters: {},
        time_travel_point: '<string>'
      },
      dataset_b: {
        connection_id: 123,
        table: '<string>',
        filter: '<string>',
        session_parameters: {},
        time_travel_point: '<string>'
      },
      primary_key: ['<string>'],
      column_remapping: {},
      columns_to_compare: ['<string>'],
      compare_duplicates: true,
      exclude_columns: ['<string>'],
      ignore_string_case: false,
      include_columns: ['<string>'],
      materialize_results: false,
      null_equals_empty_string: false,
      sampling: {confidence: 123, tolerance: 123, threshold: 123},
      sort_array_columns: true,
      timeseries_dimension_column: '<string>',
      tolerance: {
        datetime: {},
        float: {column_tolerance: {}, default: {value: 123, type: 'relative'}}
      }
    },
    name: '<string>',
    schedule: {interval: {every: '<string>', type: 'hourly'}},
    alert: {different_rows_count: 123, different_rows_percent: 123, match_ratio_min: 0.5},
    description: '<string>',
    enabled: true,
    notifications: [{recipients: ['<string>'], features: [], type: 'email'}],
    owner: '<string>',
    tags: ['<string>']
  })
};

fetch('https://app.datafold.com/api/v1/monitors/create/diff', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://app.datafold.com/api/v1/monitors/create/diff",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'datadiff' => [
        'dataset_a' => [
                'connection_id' => 123,
                'table' => '<string>',
                'filter' => '<string>',
                'session_parameters' => [
                                
                ],
                'time_travel_point' => '<string>'
        ],
        'dataset_b' => [
                'connection_id' => 123,
                'table' => '<string>',
                'filter' => '<string>',
                'session_parameters' => [
                                
                ],
                'time_travel_point' => '<string>'
        ],
        'primary_key' => [
                '<string>'
        ],
        'column_remapping' => [
                
        ],
        'columns_to_compare' => [
                '<string>'
        ],
        'compare_duplicates' => true,
        'exclude_columns' => [
                '<string>'
        ],
        'ignore_string_case' => false,
        'include_columns' => [
                '<string>'
        ],
        'materialize_results' => false,
        'null_equals_empty_string' => false,
        'sampling' => [
                'confidence' => 123,
                'tolerance' => 123,
                'threshold' => 123
        ],
        'sort_array_columns' => true,
        'timeseries_dimension_column' => '<string>',
        'tolerance' => [
                'datetime' => [
                                
                ],
                'float' => [
                                'column_tolerance' => [
                                                                
                                ],
                                'default' => [
                                                                'value' => 123,
                                                                'type' => 'relative'
                                ]
                ]
        ]
    ],
    'name' => '<string>',
    'schedule' => [
        'interval' => [
                'every' => '<string>',
                'type' => 'hourly'
        ]
    ],
    'alert' => [
        'different_rows_count' => 123,
        'different_rows_percent' => 123,
        'match_ratio_min' => 0.5
    ],
    'description' => '<string>',
    'enabled' => true,
    'notifications' => [
        [
                'recipients' => [
                                '<string>'
                ],
                'features' => [
                                
                ],
                'type' => 'email'
        ]
    ],
    'owner' => '<string>',
    'tags' => [
        '<string>'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: <api-key>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://app.datafold.com/api/v1/monitors/create/diff"

	payload := strings.NewReader("{\n  \"datadiff\": {\n    \"dataset_a\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"dataset_b\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"primary_key\": [\n      \"<string>\"\n    ],\n    \"column_remapping\": {},\n    \"columns_to_compare\": [\n      \"<string>\"\n    ],\n    \"compare_duplicates\": true,\n    \"exclude_columns\": [\n      \"<string>\"\n    ],\n    \"ignore_string_case\": false,\n    \"include_columns\": [\n      \"<string>\"\n    ],\n    \"materialize_results\": false,\n    \"null_equals_empty_string\": false,\n    \"sampling\": {\n      \"confidence\": 123,\n      \"tolerance\": 123,\n      \"threshold\": 123\n    },\n    \"sort_array_columns\": true,\n    \"timeseries_dimension_column\": \"<string>\",\n    \"tolerance\": {\n      \"datetime\": {},\n      \"float\": {\n        \"column_tolerance\": {},\n        \"default\": {\n          \"value\": 123,\n          \"type\": \"relative\"\n        }\n      }\n    }\n  },\n  \"name\": \"<string>\",\n  \"schedule\": {\n    \"interval\": {\n      \"every\": \"<string>\",\n      \"type\": \"hourly\"\n    }\n  },\n  \"alert\": {\n    \"different_rows_count\": 123,\n    \"different_rows_percent\": 123,\n    \"match_ratio_min\": 0.5\n  },\n  \"description\": \"<string>\",\n  \"enabled\": true,\n  \"notifications\": [\n    {\n      \"recipients\": [\n        \"<string>\"\n      ],\n      \"features\": [],\n      \"type\": \"email\"\n    }\n  ],\n  \"owner\": \"<string>\",\n  \"tags\": [\n    \"<string>\"\n  ]\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "<api-key>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://app.datafold.com/api/v1/monitors/create/diff")
  .header("Authorization", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"datadiff\": {\n    \"dataset_a\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"dataset_b\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"primary_key\": [\n      \"<string>\"\n    ],\n    \"column_remapping\": {},\n    \"columns_to_compare\": [\n      \"<string>\"\n    ],\n    \"compare_duplicates\": true,\n    \"exclude_columns\": [\n      \"<string>\"\n    ],\n    \"ignore_string_case\": false,\n    \"include_columns\": [\n      \"<string>\"\n    ],\n    \"materialize_results\": false,\n    \"null_equals_empty_string\": false,\n    \"sampling\": {\n      \"confidence\": 123,\n      \"tolerance\": 123,\n      \"threshold\": 123\n    },\n    \"sort_array_columns\": true,\n    \"timeseries_dimension_column\": \"<string>\",\n    \"tolerance\": {\n      \"datetime\": {},\n      \"float\": {\n        \"column_tolerance\": {},\n        \"default\": {\n          \"value\": 123,\n          \"type\": \"relative\"\n        }\n      }\n    }\n  },\n  \"name\": \"<string>\",\n  \"schedule\": {\n    \"interval\": {\n      \"every\": \"<string>\",\n      \"type\": \"hourly\"\n    }\n  },\n  \"alert\": {\n    \"different_rows_count\": 123,\n    \"different_rows_percent\": 123,\n    \"match_ratio_min\": 0.5\n  },\n  \"description\": \"<string>\",\n  \"enabled\": true,\n  \"notifications\": [\n    {\n      \"recipients\": [\n        \"<string>\"\n      ],\n      \"features\": [],\n      \"type\": \"email\"\n    }\n  ],\n  \"owner\": \"<string>\",\n  \"tags\": [\n    \"<string>\"\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.datafold.com/api/v1/monitors/create/diff")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"datadiff\": {\n    \"dataset_a\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"dataset_b\": {\n      \"connection_id\": 123,\n      \"table\": \"<string>\",\n      \"filter\": \"<string>\",\n      \"session_parameters\": {},\n      \"time_travel_point\": \"<string>\"\n    },\n    \"primary_key\": [\n      \"<string>\"\n    ],\n    \"column_remapping\": {},\n    \"columns_to_compare\": [\n      \"<string>\"\n    ],\n    \"compare_duplicates\": true,\n    \"exclude_columns\": [\n      \"<string>\"\n    ],\n    \"ignore_string_case\": false,\n    \"include_columns\": [\n      \"<string>\"\n    ],\n    \"materialize_results\": false,\n    \"null_equals_empty_string\": false,\n    \"sampling\": {\n      \"confidence\": 123,\n      \"tolerance\": 123,\n      \"threshold\": 123\n    },\n    \"sort_array_columns\": true,\n    \"timeseries_dimension_column\": \"<string>\",\n    \"tolerance\": {\n      \"datetime\": {},\n      \"float\": {\n        \"column_tolerance\": {},\n        \"default\": {\n          \"value\": 123,\n          \"type\": \"relative\"\n        }\n      }\n    }\n  },\n  \"name\": \"<string>\",\n  \"schedule\": {\n    \"interval\": {\n      \"every\": \"<string>\",\n      \"type\": \"hourly\"\n    }\n  },\n  \"alert\": {\n    \"different_rows_count\": 123,\n    \"different_rows_percent\": 123,\n    \"match_ratio_min\": 0.5\n  },\n  \"description\": \"<string>\",\n  \"enabled\": true,\n  \"notifications\": [\n    {\n      \"recipients\": [\n        \"<string>\"\n      ],\n      \"features\": [],\n      \"type\": \"email\"\n    }\n  ],\n  \"owner\": \"<string>\",\n  \"tags\": [\n    \"<string>\"\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "id": 123
}

{
  "detail": [
    {
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>",
      "ctx": {},
      "input": "<unknown>"
    }
  ]
}