Skip to content

Clickhouse Mashup

POST
/clickhouse/mashup

Enrich UP_IDs / HEMs / domains against the ClickHouse Cloud mashup tables.

Use this for bulk enrichment workflows where the agent already has a primary key (UP_ID from g8_opensearch_resolve_ids, a HEM from a visitor row, or a company domain from CRM). For free-form attribute search prefer g8_opensearch_search against mashup_contacts.

Authorizations

Parameters

Header Parameters

X-Target-Org-Id
Any of:
string

Request Body required

object
limit
integer
default: 1000 >= 1 <= 1000
mode
required

Which mashup PK to filter by.

string
Allowed values: by_upid by_hem by_domain
profile

Which mashup table to read. ‘joined’ returns the lighter denormalized mashup_new with both profiles partially populated.

string
default: b2b
Allowed values: b2b b2c joined
values
required

Up to 100 key values (UP_IDs, HEMs, or domains).

Array<string>
>= 1 items <= 100 items

Responses

200

Successful Response

object
data
required
object
matched
integer
mode
required
string
profile
required
string
records
Array<object>
default:
object
key
additional properties
any
requested
integer
pagination
Any of:
object
has_next
required

Whether there are more pages

boolean
limit
required

Items per page

integer
next_cursor
Any of:
string
page
required

Current page number (1-indexed)

integer
total
required

Total number of items

integer

422

Validation Error

object
detail
Array<object>
object
loc
required
Array
msg
required
string
type
required
string