InfoSum Developer Documentation (1.0)
Download OpenAPI specification:Download
This page contains the documentation for the InfoSum Developer API. The methods allow you to try making requests and inspect the input and output formats.
List Activations
List current activations, subject to the optional request filters.
query Parameters
filter.campaign_name | string Campaign Name. The filter to be applied to the campaign name. Case insensitive. Supports partial names. |
filter.submitted_at_filter.start_time | string <date-time> Start. Defines the earliest time the filter is applied from. The filter matches all dates after this point in time, inclusive. |
filter.submitted_at_filter.end_time | string <date-time> End. Defines the time the filter is applied until. The filter matches all dates before this point in time, inclusive. |
filter.query_successful | boolean Query Successful. Filters activations that were successfully completed or not. |
filter.results_expired | boolean Results Expired. Filters activations that have expired or not. |
filter.push_destinations | Array of strings Push Destinations. Filters queries that have been pushed to the specified destinations. |
filter.output_columns | Array of strings Output Columns. Filters activations by the selected output columns. Activations which contain any of the specified output columns are included in the result |
filter.activation_dataset_private_ids | Array of strings Activation Dataset Private IDs. Filters queries by the activation dataset private ID used in the query. Activations for any of the dataset private IDs specified are included in the result. |
filter.project_ids | Array of strings Project IDs. Filters queries by the projects that the activation dataset belongs to. Activations whose dataset belongs to any of the specified projects are included in the result. |
sort.by | string By is the field to sort by. |
sort.order | string Default: "ASCENDING" Enum: "ASCENDING" "DESCENDING" Order is the order to sort in. Defaults to ascending.
|
Responses
Response samples
- 200
- 401
- 403
- default
{- "activations": [
- {
- "activation_id": "string",
- "campaign_name": "string",
- "status": "QUERY_PENDING",
- "total_rows": 0,
- "submitted_at": "2019-08-24T14:15:22Z",
- "query_successful": true,
- "results_expired": true,
- "dataset_id": "string",
- "project_ids": [
- "string"
], - "column_separator": "string",
- "string_literal_column": {
- "column_name": "string",
- "column_literal": "string"
}, - "original_record_count": 0
}
]
}
Queue an Activation
Create an Activation and queue the query for execution. Returns immediately with an ID of the Activation created. Use the Get Activation endpoint to see if the query has run. Only available for use with Activation Datasets.
Request Body schema: application/jsonrequired
query | string (Query) The Query that should be executed. This takes the format of an InfoSum Activation Query. See the documentation of the InfoSum Activation Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. | |
campaign_name | string (CampaignName) A name that a user can associate with an activation query. |
column_separator | string (Column Separator) The separator to be used to delimit activation data columns. |
object (tyraelActivationStringLiteral) ActivationStringLiteral contains information about a string literal activation column. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
], - "campaign_name": "string",
- "column_separator": "string",
- "string_literal_column": {
- "column_name": "string",
- "column_literal": "string"
}
}
Response samples
- 200
- 400
- 401
- 403
- 404
- default
{- "activation_id": "string",
- "query_completed": true,
- "query_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}, - "query_response": {
- "identities": [
- "string"
], - "total_rows": 0,
- "quality_measures": {
- "redaction_threshold_outlier": 0.1,
- "model_accuracy": 0.1
}
}
}
Validates an Activation Query
Performs validation of an Activation Query without executing it.
Request Body schema: application/jsonrequired
query | string (Query) The query to be validated. This takes the format of an IQL Query. See the documentation of the IQL for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. | |
object (tyraelActivationStringLiteral) ActivationStringLiteral contains information about a string literal activation column. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
], - "string_literal_column": {
- "column_name": "string",
- "column_literal": "string"
}
}
Response samples
- 200
- 400
- 401
- 403
- default
{- "success": true
}
Get an Activation
Get detailed information about an Activation, including query and push statuses.
path Parameters
activation_id required | string Activation ID The unique ID of the activation to get. |
Responses
Response samples
- 200
- 401
- 403
- 404
- default
{- "activation": {
- "summary": {
- "activation_id": "string",
- "campaign_name": "string",
- "status": "QUERY_PENDING",
- "total_rows": 0,
- "submitted_at": "2019-08-24T14:15:22Z",
- "query_successful": true,
- "results_expired": true,
- "dataset_id": "string",
- "project_ids": [
- "string"
], - "column_separator": "string",
- "string_literal_column": {
- "column_name": "string",
- "column_literal": "string"
}, - "original_record_count": 0
}, - "query_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}, - "output_columns": [
- "string"
], - "pushes": [
- {
- "push_id": "string",
- "status": "PUSH_PENDING",
- "connector_type": "string",
- "pushed_at": "2019-08-24T14:15:22Z",
- "completed_at": "2019-08-24T14:15:22Z",
- "push_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}, - "push_successful": true
}
], - "query_string": "string"
}
}
Pushes the activation query results to the specified push connector
Pushes the result of an activation query to the specified push connector
path Parameters
activation_id required | string Activation ID The ID of the activation to push the results of. |
Request Body schema: application/jsonrequired
push_connector_id | string (Push Connector ID) Is the ID of the Push Connector to push the results to. |
object (PushConnectorConfig) The push connector map of Configuration Form field IDs to their values for configuring the push connector. |
Responses
Request samples
- Payload
{- "push_connector_id": "string",
- "push_connector_config": {
- "property1": "string",
- "property2": "string"
}
}
Response samples
- 200
- 400
- 401
- 403
- 404
- default
{- "push_id": "string"
}
List the permitted Push Connectors for an Activation Query
Returns a list of all the Push Connectors that can be used with the specified Activation Query.
path Parameters
activation_id required | string Activation ID Is the ID of the activation to list the permitted push connectors for. |
Responses
Response samples
- 200
- 401
- 403
- 404
- default
{- "push_connectors": [
- {
- "id": "string",
- "name": "string"
}
]
}
List all Push Connectors
List all Push Connectors that the recipient can use to push the results from an Identity Query.
query Parameters
recipient_id | string RecipientId. The ListPushConnectors method will return all PushConnectors that can be used by the user with this ID. |
Responses
Response samples
- 200
- 401
- default
{- "push_connectors": [
- {
- "id": "string",
- "name": "string"
}
]
}
Create a Push Connector
Create a new Push Connector, based on an existing type of Push Connector, that can be used to push the results from an Identity Query.
path Parameters
base_id required | string BaseId The ID of the base Push Connector that the new Push Connector is based on. |
Request Body schema: application/jsonrequired
name | string (Name) A descriptive name for the new Push Connector. |
recipient_ids | Array of strings (RecipientIds) A list of the user IDs of users who can use the new Push Connector. Only users in this list will be allowed to use the new template. If left empty, any user will be allowed to use the new template if the owner specifies it in a permission shared with them. |
Array of objects (Values) Values is a list of modified fields for the new Push Connector. Any fields present in the base Push Connector that aren't in this list will be left unchanged in the new Push Connector. |
Responses
Request samples
- Payload
{- "name": "string",
- "recipient_ids": [
- "string"
], - "values": [
- {
- "field_id": "string",
- "value": "string",
- "user_editable": true
}
]
}
Response samples
- 200
- 401
- default
{- "push_connector": {
- "id": "string",
- "name": "string"
}
}
Get a Form for a Push Connector
Returns a Form which describes the values that need to be specified in order to configure a Push Connector.
path Parameters
push_connector_id required | string PushConnectorId The ID of the Push Connector. |
query Parameters
user_email_domain | string UserEmailDomain is the domain part only of the requesting user's email address. |
Responses
Response samples
- 200
- 401
- 404
- default
{- "form": {
- "panels": [
- {
- "label": "string",
- "fields": [
- {
- "id": "string",
- "label": "string",
- "options": [
- "string"
]
}
]
}
]
}
}
List all available Connections
List all Connections available from user owned Datasets to Datasets which the user has been granted access.
query Parameters
filter.origin_private_ids | Array of strings Origin Private Dataset IDs. The private IDs of the Datasets to display all connections from. |
filter.connected_datasets.private_ids | Array of strings PrivateIds. The filter to be applied to the private IDs of the returned Datasets. Only Datasets with private IDs containing one of the strings specified in this filter will be returned. Case insensitive. |
filter.connected_datasets.public_names | Array of strings PublicNames. The filter to be applied to the public names of the returned Datasets. Only Datasets with public names containing one of the string specified in this filter will be returned. Case insensitive. |
filter.connected_datasets.public_description | string PublicDescription. The filter to be applied to the public descriptions of the returned Datasets. Only Datasets with public descriptions containing the string specified in this filter will be returned. Case insensitive. |
filter.connected_datasets.create_time_filter.start_time | string <date-time> Start. Defines the earliest time the filter is applied from. The filter matches all dates after this point in time, inclusive. |
filter.connected_datasets.create_time_filter.end_time | string <date-time> End. Defines the time the filter is applied until. The filter matches all dates before this point in time, inclusive. |
filter.connected_datasets.owner_ids | Array of strings Owner User IDs. Filters Datasets on the specified owner user IDs. |
filter.connected_datasets.categories.ids | Array of strings <int64> [ items <int64 > ] Ids. The IDs of the Categories that must be present in the Dataset. |
filter.connected_datasets.categories.min_fill_rates | Array of numbers <double> [ items <double > ] MinFillRates. The minimum fill rates for each category specified in Ids. These are inclusive of the bound. A value must be specified for each Category. If the user doesn't want to filter by fill rate, they can set the minimum fill rate to 0, which will match all fill rate values. Values should be in the range 0 to 1, inclusive. |
filter.connected_datasets.project_ids | Array of strings ProjectIds. The filter to be applied to the projects associated with the returned Datasets. Only Datasets within projects matching one of the project ids specified in this filter will be returned. Case insensitive. |
filter.min_intersection | number <double> Min Intersection. The lowest acceptable intersection relative to the size of the connected Dataset. This is calculated by taking the number of rows in the from Dataset that are also in the to Dataset when using the 'best' key, and diving by the total number of rows in the from Dataset. Values can be between 0 and 1, inclusive. If ommitted, any intersection will be allowed. |
sort.by | string By is the field to sort by. |
sort.order | string Default: "ASCENDING" Enum: "ASCENDING" "DESCENDING" Order is the order to sort in. Defaults to ascending.
|
Responses
Response samples
- 200
- 400
- 401
- default
{- "connections": [
- {
- "from_dataset_private_id": "string",
- "to_dataset_private_id": "string",
- "keys": [
- {
- "name": "string",
- "intersection": "string",
- "duplicates": "string",
- "bad_estimate": true,
- "union": "string",
- "exclude": "string",
- "intersection_expansion_count": "string",
- "intersection_reduction_count": "string"
}
], - "selected_key_name": "string"
}
], - "Datasets": [
- {
- "private_id": "string",
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "public_name": "string",
- "public_description": "string",
- "create_time": "2019-08-24T14:15:22Z",
- "last_queried_time": "2019-08-24T14:15:22Z",
- "expire_time": "2019-08-24T14:15:22Z",
- "state": {
- "bunker_state": "CLAIMED",
- "progress": 0.1
}, - "latest_access": {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "access_time": "2019-08-24T14:15:22Z"
}, - "stats": {
- "version": {
- "version": "string",
- "last_normalised_time": "2019-08-24T14:15:22Z",
- "global_schema_id": "string",
- "global_schema_name": "string",
- "global_schema_status": "string",
- "dataset_version": "string"
}, - "row_count": "string",
- "redaction_threshold": 0,
- "keys": [
- {
- "label": "string",
- "null_fraction": 0.1,
- "num_distinct": 0.1
}
], - "categories": [
- {
- "label": "string",
- "representations": [
- {
- "label": "string",
- "data_type": "STRINGS",
- "precision": 0.1,
- "statistics": {
- "average": 0.1,
- "standard_deviation": 0.1,
- "percentiles": [
- null
], - "null_fraction": 0.1,
- "num_distinct": 0.1,
- "most_common": [
- null
]
}, - "possible_values": [
- "string"
]
}
], - "version": "string",
- "unit": "string"
}
], - "identities": [
- {
- "name": "string"
}
]
}, - "credits": {
- "allocation": 0,
- "current_allocation": 0,
- "used": 0,
- "shares": [
- {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}
]
}, - "product": "INSIGHT"
}
]
}
Get metadata for a Connection
Gets metadata for a specific Connection between two Datasets.
path Parameters
first_private_id required | string First Private Datasets ID The Private ID of the first Dataset in this Connection. |
second_private_id required | string Second Datasets ID The Private ID of the second Dataset in this Connection. |
Responses
Response samples
- 200
- 401
- 404
- default
{- "connection": {
- "from_dataset_private_id": "string",
- "to_dataset_private_id": "string",
- "keys": [
- {
- "name": "string",
- "intersection": "string",
- "duplicates": "string",
- "bad_estimate": true,
- "union": "string",
- "exclude": "string",
- "intersection_expansion_count": "string",
- "intersection_reduction_count": "string"
}
], - "selected_key_name": "string"
}
}
List Datasets
Lists Datasets the user has access to.
query Parameters
filter.ownership | string Default: "ANY_OWNERSHIP" Enum: "ANY_OWNERSHIP" "OWNED" "NOT_OWNED" OwnershipFilter. Specifies whether to return all Datasets, or only those that are owned or not owned by the requesting user.
|
filter.datasets.private_ids | Array of strings PrivateIds. The filter to be applied to the private IDs of the returned Datasets. Only Datasets with private IDs containing one of the strings specified in this filter will be returned. Case insensitive. |
filter.datasets.public_names | Array of strings PublicNames. The filter to be applied to the public names of the returned Datasets. Only Datasets with public names containing one of the string specified in this filter will be returned. Case insensitive. |
filter.datasets.public_description | string PublicDescription. The filter to be applied to the public descriptions of the returned Datasets. Only Datasets with public descriptions containing the string specified in this filter will be returned. Case insensitive. |
filter.datasets.create_time_filter.start_time | string <date-time> Start. Defines the earliest time the filter is applied from. The filter matches all dates after this point in time, inclusive. |
filter.datasets.create_time_filter.end_time | string <date-time> End. Defines the time the filter is applied until. The filter matches all dates before this point in time, inclusive. |
filter.datasets.owner_ids | Array of strings Owner User IDs. Filters Datasets on the specified owner user IDs. |
filter.datasets.categories.ids | Array of strings <int64> [ items <int64 > ] Ids. The IDs of the Categories that must be present in the Dataset. |
filter.datasets.categories.min_fill_rates | Array of numbers <double> [ items <double > ] MinFillRates. The minimum fill rates for each category specified in Ids. These are inclusive of the bound. A value must be specified for each Category. If the user doesn't want to filter by fill rate, they can set the minimum fill rate to 0, which will match all fill rate values. Values should be in the range 0 to 1, inclusive. |
filter.datasets.project_ids | Array of strings ProjectIds. The filter to be applied to the projects associated with the returned Datasets. Only Datasets within projects matching one of the project ids specified in this filter will be returned. Case insensitive. |
sort.by | string By is the field to sort by. |
sort.order | string Default: "ASCENDING" Enum: "ASCENDING" "DESCENDING" Order is the order to sort in. Defaults to ascending.
|
Responses
Response samples
- 200
- 400
- 401
- default
{- "Datasets": [
- {
- "private_id": "string",
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "public_name": "string",
- "public_description": "string",
- "create_time": "2019-08-24T14:15:22Z",
- "last_queried_time": "2019-08-24T14:15:22Z",
- "expire_time": "2019-08-24T14:15:22Z",
- "state": {
- "bunker_state": "CLAIMED",
- "progress": 0.1
}, - "latest_access": {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "access_time": "2019-08-24T14:15:22Z"
}, - "stats": {
- "version": {
- "version": "string",
- "last_normalised_time": "2019-08-24T14:15:22Z",
- "global_schema_id": "string",
- "global_schema_name": "string",
- "global_schema_status": "string",
- "dataset_version": "string"
}, - "row_count": "string",
- "redaction_threshold": 0,
- "keys": [
- {
- "label": "string",
- "null_fraction": 0.1,
- "num_distinct": 0.1
}
], - "categories": [
- {
- "label": "string",
- "representations": [
- {
- "label": "string",
- "data_type": "STRINGS",
- "precision": 0.1,
- "statistics": {
- "average": 0.1,
- "standard_deviation": 0.1,
- "percentiles": [
- null
], - "null_fraction": 0.1,
- "num_distinct": 0.1,
- "most_common": [
- null
]
}, - "possible_values": [
- "string"
]
}
], - "version": "string",
- "unit": "string"
}
], - "identities": [
- {
- "name": "string"
}
]
}, - "credits": {
- "allocation": 0,
- "current_allocation": 0,
- "used": 0,
- "shares": [
- {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}
]
}, - "product": "INSIGHT"
}
]
}
Get Dataset metadata
Gets metadata for a specific Dataset the user owns or has access to.
path Parameters
private_id required | string Private Dataset ID The Private ID of the Dataset to retrieve, as assigned by the user. |
Responses
Response samples
- 200
- 401
- 404
- default
{- "dataset": {
- "private_id": "string",
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "public_name": "string",
- "public_description": "string",
- "create_time": "2019-08-24T14:15:22Z",
- "last_queried_time": "2019-08-24T14:15:22Z",
- "expire_time": "2019-08-24T14:15:22Z",
- "state": {
- "bunker_state": "CLAIMED",
- "progress": 0.1
}, - "latest_access": {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "access_time": "2019-08-24T14:15:22Z"
}, - "stats": {
- "version": {
- "version": "string",
- "last_normalised_time": "2019-08-24T14:15:22Z",
- "global_schema_id": "string",
- "global_schema_name": "string",
- "global_schema_status": "string",
- "dataset_version": "string"
}, - "row_count": "string",
- "redaction_threshold": 0,
- "keys": [
- {
- "label": "string",
- "null_fraction": 0.1,
- "num_distinct": 0.1
}
], - "categories": [
- {
- "label": "string",
- "representations": [
- {
- "label": "string",
- "data_type": "STRINGS",
- "precision": 0.1,
- "statistics": {
- "average": 0.1,
- "standard_deviation": 0.1,
- "percentiles": [
- 0.1
], - "null_fraction": 0.1,
- "num_distinct": 0.1,
- "most_common": [
- {
- "value": null,
- "frequency": null
}
]
}, - "possible_values": [
- "string"
]
}
], - "version": "string",
- "unit": "string"
}
], - "identities": [
- {
- "name": "string"
}
]
}, - "credits": {
- "allocation": 0,
- "current_allocation": 0,
- "used": 0,
- "shares": [
- {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}
]
}, - "product": "INSIGHT"
}, - "schema": {
- "version": "string",
- "update_time": "2019-08-24T14:15:22Z",
- "categories": [
- {
- "label": "string",
- "representations": [
- {
- "label": "string",
- "data_type": "STRINGS",
- "precision": 0.1,
- "statistics": {
- "average": 0.1,
- "standard_deviation": 0.1,
- "percentiles": [
- 0.1
], - "null_fraction": 0.1,
- "num_distinct": 0.1,
- "most_common": [
- {
- "value": "string",
- "frequency": 0.1
}
]
}, - "possible_values": [
- "string"
]
}
], - "version": "string",
- "unit": "string"
}
], - "num_rows": "string",
- "redaction_threshold": 0,
- "keys": [
- {
- "label": "string",
- "null_fraction": 0.1,
- "num_distinct": 0.1
}
]
}
}
Get Dataset credit usage
Gets a time series of credit usage on the specified Dataset.
path Parameters
private_id required | string Private Dataset ID The Private ID of the Dataset to return usage data for. |
query Parameters
start_time | string <date-time> Start Time. The timestamp from which to return usage data. If not specified, will default to the beginning of the current month. If specified, the StartTime will be rounded down to the next group boundary as specified by Grouping. |
end_time | string <date-time> End Time. The timestamp up to which to return usage data. If not specified, will return all data up to the present moment. The EndTime will be rounded up to the next group boundary as specified by Grouping. |
grouping | string Default: "TIME_GROUPING_UNSPECIFIED" Enum: "TIME_GROUPING_UNSPECIFIED" "DAY" "WEEK" "MONTH" "YEAR" Grouping. Specifies how to roll up a time series into discrete groups.
|
Responses
Response samples
- 200
- 400
- 401
- 404
- default
{- "timeseries": [
- {
- "timestamp": "2019-08-24T14:15:22Z",
- "usage": {
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "allocation": 0,
- "current_allocation": 0,
- "used": 0,
- "permissions": [
- {
- "recipient": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}
]
}
}
]
}
Add access to the Demo Datasets
Add access to the Demo Datasets for querying.
Request Body schema: application/jsonrequired
Used to add Demo Datasets with the AddDemoDatasets method.
Responses
Request samples
- Payload
{ }
Response samples
- 200
- 401
- 404
- default
{- "permissions": [
- {
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "private_id": "string",
- "recipient": {
- "id": "string",
- "display_name": "string"
}, - "create_time": "2019-08-24T14:15:22Z",
- "accept_time": "2019-08-24T14:15:22Z",
- "accepted": true,
- "credits": {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}, - "dataset_public_name": "string",
- "dataset_public_desc": "string"
}
]
}
ExplainQuery explains how a query will be executed.
Provides information about the choices made by the platfrom before executing a query.
Request Body schema: application/jsonrequired
query | string (Query) The Query whose execution will be explained. This takes the format of an InfoSum Query Language Query. See the documentation of the InfoSum Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
]
}
Response samples
- 200
- 400
- 401
- default
{- "query_plan": {
- "query": "string",
- "plan": {
- "private_id": "string",
- "representation": {
- "category": "string",
- "selected_representation": "string",
- "inferred": true,
- "bins": [
- "string"
], - "filter": "string",
- "representations": [
- {
- "name": "string",
- "type": "string",
- "score": 0.1,
- "precision": 0.1,
- "bins": [
- "string"
], - "filter": "string"
}
]
}, - "aggregation_joins": {
- "combinator": {
- "type": "AND",
- "joins": [
- { }
]
}, - "id": 0,
- "from_private_id": "string",
- "to_private_id": "string",
- "representation": {
- "category": "string",
- "selected_representation": "string",
- "inferred": true,
- "bins": [
- "string"
], - "filter": "string",
- "representations": [
- {
- "name": "string",
- "type": "string",
- "score": 0.1,
- "precision": 0.1,
- "bins": [
- "string"
], - "filter": "string"
}
]
}, - "keys": {
- "max_overcounted": 0,
- "used": [
- "string"
], - "keys": [
- {
- "key_name": "string",
- "overlap": "string",
- "duplicates": "string",
- "from_dataset_size": "string",
- "to_dataset_size": "string"
}
], - "inferred": true
}
}, - "filter_joins": {
- "combinator": {
- "type": "AND",
- "joins": [
- { }
]
}, - "id": 0,
- "from_private_id": "string",
- "to_private_id": "string",
- "representation": {
- "category": "string",
- "selected_representation": "string",
- "inferred": true,
- "bins": [
- "string"
], - "filter": "string",
- "representations": [
- {
- "name": "string",
- "type": "string",
- "score": 0.1,
- "precision": 0.1,
- "bins": [
- "string"
], - "filter": "string"
}
]
}, - "keys": {
- "max_overcounted": 0,
- "used": [
- "string"
], - "keys": [
- {
- "key_name": "string",
- "overlap": "string",
- "duplicates": "string",
- "from_dataset_size": "string",
- "to_dataset_size": "string"
}
], - "inferred": true
}
}
}, - "results": {
- "max_overcounted_values": 0,
- "dimensions": [
- {
- "private_id": "string",
- "category": "string",
- "bins": [
- "string"
], - "inferred_bins": true
}
], - "filter": "string",
- "rounding_threshold": {
- "threshold": 0,
- "Datasets": [
- {
- "private_id": "string",
- "threshold": 0
}
]
}, - "redaction_threshold": {
- "threshold": 0,
- "Datasets": [
- {
- "private_id": "string",
- "threshold": 0
}
]
}
}
}, - "hop_table": [
- {
- "id": 0,
- "join_id": 0,
- "from_private_id": "string",
- "to_private_id": "string",
- "key_name": "string",
- "overlap": "string",
- "duplicates": "string",
- "from_dataset_size": "string",
- "to_dataset_size": "string",
- "max_overcounted_values": 0,
- "representation": {
- "category": "string",
- "selected_representation": "string",
- "inferred": true,
- "bins": [
- "string"
], - "filter": "string",
- "representations": [
- {
- "name": "string",
- "type": "string",
- "score": 0.1,
- "precision": 0.1,
- "bins": [
- "string"
], - "filter": "string"
}
]
}
}
]
}
Create a Query
Queue a Query for execution. Returns immediately with an ID of the Query created.
Request Body schema: application/jsonrequired
query | string (Query) The Query that should be queued. This takes the format of an InfoSum Query Language Query. See the documentation of the InfoSum Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. | |
sample | boolean (Sample) A flag that can be used to execute the query against a smaller sample of the data. Can be used to reduce the execution time for a less accurate result. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
], - "sample": true
}
Response samples
- 200
- 400
- 401
- default
{- "query_id": "string",
- "done": true
}
Get a Result
Get the Result of a Query, when it is available.
path Parameters
query_id required | string Query ID The ID of the Query, as returned from the CreateQuery method. |
Responses
Response samples
- 200
- 401
- 404
- default
{- "dimensions": [
- {
- "value": "string",
- "category": "string",
- "count": 0,
- "continuous": true,
- "private_id": "string",
- "dimensions": [
- { }
]
}
], - "audience": 0,
- "quality_measures": {
- "redaction_threshold_outlier": 0.1,
- "rounding_threshold_outlier": 0.1,
- "model_accuracy": 0.1,
- "result_precision_include_empty_bins": 0.1,
- "result_precision_exclude_empty_bins": 0.1
}
}
ValidateQuery validates a query
Performs validation of a query without actually executing it. Good for testing that your queries are correctly formatted.
Request Body schema: application/jsonrequired
query | string (Query) The Query that should be validated. This takes the format of an InfoSum Query Language Query. See the documentation of the InfoSum Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
]
}
Response samples
- 200
- 400
- 401
- default
{- "success": true
}
Create an Identity Query Deprecated
Queue an Identity Query for execution. Returns immediately with an ID of the Identity Query created. Only available for use with Identity Datasets.
Request Body schema: application/jsonrequired
query | string (Query) The Query that should be queued. This takes the format of an InfoSum Identity Query. See the documentation of the InfoSum Identity Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. | |
object (Push Connector Config) The configuration for a Push Connector. | |
campaign_id | string (CampaignId) A name that a user can associate with an identity query. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
], - "push_connector_config": {
- "id": "string",
- "config": {
- "property1": "string",
- "property2": "string"
}
}, - "campaign_id": "string"
}
Response samples
- 200
- 400
- 401
- default
{- "identity_query_id": "string",
- "query_completed": true,
- "query_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}, - "query_response": {
- "identities": [
- "string"
], - "total_rows": 0,
- "quality_measures": {
- "redaction_threshold_outlier": 0.1,
- "model_accuracy": 0.1
}
}, - "push_completed": true,
- "push_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}
}
Get a list of Push Connectors permitted for an Identity Query Deprecated
Returns a list of all the Push Connectors that can be used with this Identity Query.
Request Body schema: application/jsonrequired
private_id | string (Private Dataset ID) The Private ID of the Dataset to retrieve, as assigned by the user. |
Responses
Request samples
- Payload
{- "private_id": "string"
}
Response samples
- 200
- 400
- 401
- default
{- "push_connectors": [
- {
- "id": "string",
- "name": "string"
}
]
}
Validates an Identity Query Deprecated
Performs validation of an Identity Query without actually executing it. Good for testing that your queries are correctly formatted.
Request Body schema: application/jsonrequired
query | string (Query) The Query that should be queued. This takes the format of an InfoSum Identity Query. See the documentation of the InfoSum Identity Query Language for more information. |
Array of objects (Path Overrides) A list of instructions on how to connect two datasets, overriding the automatic choices made by the core engine. | |
object (Push Connector Config) The configuration for a Push Connector. |
Responses
Request samples
- Payload
{- "query": "string",
- "path_overrides": [
- {
- "source_dataset": {
- "private_id": "string",
- "keys": [
- "string"
]
}, - "destination_private_id": "string"
}
], - "push_connector_config": {
- "id": "string",
- "config": {
- "property1": "string",
- "property2": "string"
}
}
}
Response samples
- 200
- 400
- 401
- default
{- "success": true
}
Get an Identity Query Deprecated
Get the current status of the Identity Query.
path Parameters
identity_query_id required | string Identity Query ID The ID of the Identity Query, as returned from the CreateIdentityQuery method. |
Responses
Response samples
- 200
- 401
- 404
- default
{- "identity_query_id": "string",
- "query_completed": true,
- "query_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}, - "query_response": {
- "identities": [
- "string"
], - "total_rows": 0,
- "quality_measures": {
- "redaction_threshold_outlier": 0.1,
- "model_accuracy": 0.1
}
}, - "push_completed": true,
- "push_error": {
- "code": 0,
- "message": "string",
- "details": [
- {
- "type_url": "string",
- "value": "string"
}
]
}
}
List all Permissions associated with the User.
List all Permissions the user has offered or been offered.
query Parameters
filter.direction | string Default: "ANY_DIRECTION" Enum: "ANY_DIRECTION" "INCOMING" "OUTGOING" Direction. Specifies whether to return all Permissions, or only those that are incoming or outgoing.
|
filter.accepted | string Default: "ANY_ACCEPTED" Enum: "ANY_ACCEPTED" "INACTIVE" "ACTIVE" Accepted. Specifies whether to return all Permissions, or only those that have or have not been accepted by the recipient.
|
filter.owned_datasets.private_ids | Array of strings PrivateIds. The filter to be applied to the private IDs of the returned Datasets. Only Datasets with private IDs containing one of the strings specified in this filter will be returned. Case insensitive. |
filter.owned_datasets.public_names | Array of strings PublicNames. The filter to be applied to the public names of the returned Datasets. Only Datasets with public names containing one of the string specified in this filter will be returned. Case insensitive. |
filter.owned_datasets.public_description | string PublicDescription. The filter to be applied to the public descriptions of the returned Datasets. Only Datasets with public descriptions containing the string specified in this filter will be returned. Case insensitive. |
filter.owned_datasets.create_time_filter.start_time | string <date-time> Start. Defines the earliest time the filter is applied from. The filter matches all dates after this point in time, inclusive. |
filter.owned_datasets.create_time_filter.end_time | string <date-time> End. Defines the time the filter is applied until. The filter matches all dates before this point in time, inclusive. |
filter.owned_datasets.owner_ids | Array of strings Owner User IDs. Filters Datasets on the specified owner user IDs. |
filter.owned_datasets.categories.ids | Array of strings <int64> [ items <int64 > ] Ids. The IDs of the Categories that must be present in the Dataset. |
filter.owned_datasets.categories.min_fill_rates | Array of numbers <double> [ items <double > ] MinFillRates. The minimum fill rates for each category specified in Ids. These are inclusive of the bound. A value must be specified for each Category. If the user doesn't want to filter by fill rate, they can set the minimum fill rate to 0, which will match all fill rate values. Values should be in the range 0 to 1, inclusive. |
filter.owned_datasets.project_ids | Array of strings ProjectIds. The filter to be applied to the projects associated with the returned Datasets. Only Datasets within projects matching one of the project ids specified in this filter will be returned. Case insensitive. |
filter.other_datasets.private_ids | Array of strings PrivateIds. The filter to be applied to the private IDs of the returned Datasets. Only Datasets with private IDs containing one of the strings specified in this filter will be returned. Case insensitive. |
filter.other_datasets.public_names | Array of strings PublicNames. The filter to be applied to the public names of the returned Datasets. Only Datasets with public names containing one of the string specified in this filter will be returned. Case insensitive. |
filter.other_datasets.public_description | string PublicDescription. The filter to be applied to the public descriptions of the returned Datasets. Only Datasets with public descriptions containing the string specified in this filter will be returned. Case insensitive. |
filter.other_datasets.create_time_filter.start_time | string <date-time> Start. Defines the earliest time the filter is applied from. The filter matches all dates after this point in time, inclusive. |
filter.other_datasets.create_time_filter.end_time | string <date-time> End. Defines the time the filter is applied until. The filter matches all dates before this point in time, inclusive. |
filter.other_datasets.owner_ids | Array of strings Owner User IDs. Filters Datasets on the specified owner user IDs. |
filter.other_datasets.categories.ids | Array of strings <int64> [ items <int64 > ] Ids. The IDs of the Categories that must be present in the Dataset. |
filter.other_datasets.categories.min_fill_rates | Array of numbers <double> [ items <double > ] MinFillRates. The minimum fill rates for each category specified in Ids. These are inclusive of the bound. A value must be specified for each Category. If the user doesn't want to filter by fill rate, they can set the minimum fill rate to 0, which will match all fill rate values. Values should be in the range 0 to 1, inclusive. |
filter.other_datasets.project_ids | Array of strings ProjectIds. The filter to be applied to the projects associated with the returned Datasets. Only Datasets within projects matching one of the project ids specified in this filter will be returned. Case insensitive. |
sort.by | string By is the field to sort by. |
sort.order | string Default: "ASCENDING" Enum: "ASCENDING" "DESCENDING" Order is the order to sort in. Defaults to ascending.
|
Responses
Response samples
- 200
- 400
- 401
- default
{- "permissions": [
- {
- "owner": {
- "id": "string",
- "display_name": "string"
}, - "private_id": "string",
- "recipient": {
- "id": "string",
- "display_name": "string"
}, - "create_time": "2019-08-24T14:15:22Z",
- "accept_time": "2019-08-24T14:15:22Z",
- "accepted": true,
- "credits": {
- "user": {
- "id": "string",
- "display_name": "string"
}, - "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true
}, - "dataset_public_name": "string",
- "dataset_public_desc": "string"
}
]
}
Get Permission credit usage
Gets a time series of credit usage on the specified Dataset.
path Parameters
private_id required | string Private Dataset ID The Private ID of the Dataset that the Permission is from, which identifies the Permission to return usage data for when combined with RecipientId. |
recipient_id required | string Recipient user ID The user ID of the recipient of the Permission to return usage data for, which identifies a single Permission when combined with Dataset ID. |
query Parameters
start_time | string <date-time> Start Time. The timestamp from which to return usage data. If not specified, will default to the beginning of the current month. If specified, the StartTime will be rounded down to the next group boundary as specified by Grouping. |
end_time | string <date-time> End Time. The timestamp up to which to return usage data. If not specified, will return all data up to the present moment. The EndDate will be rounded up to the next group boundary as specified by Grouping. |
grouping | string Default: "TIME_GROUPING_UNSPECIFIED" Enum: "TIME_GROUPING_UNSPECIFIED" "DAY" "WEEK" "MONTH" "YEAR" Grouping. Specifies how to roll up a time series into discrete groups.
|
Responses
Response samples
- 200
- 400
- 401
- 404
- default
{- "timeseries": [
- {
- "timestamp": "2019-08-24T14:15:22Z",
- "usage": {
- "allowance": 0,
- "current_allowance": 0,
- "used": 0,
- "uses_parent_allocation": true,
- "parent_allocation": 0,
- "current_parent_allocation": 0
}
}
]
}