...
| Code Block |
|---|
{
"response": {
"status": "OK",
"change_count": 1069,
"changes": [
{
"id": "102",
"customer": "50",
"old": "SELECT DISTINCT goc.uuid FROM demosummit.go_customer_orc goc WHERE (bdate >= '{$date-7}' AND bdate < '{$date}') AND goc.uuid NOT IN ('0','1','2','3','4','5') AND (( ((("site_domain" LIKE '%football%'))) AND ((((CAST(day_of_week(date_parse(((( cast(nullif(nullif(lower("bdate"), 'null'), '0') AS varchar)))), '%Y-%m-%d')) As varchar))) IN ('6','7'))) )) ",
"new": "SELECT /* audience_id=102 */ DISTINCT goc.uuid FROM demosummit.go_customer_orc goc WHERE (bdate >= '{$date-7}' AND bdate <= '{$date}') AND goc.uuid NOT IN ('0','1','2','3','4','5') AND (( ((("site_domain" LIKE '%football%'))) AND ((((CAST(day_of_week(date_parse(((( cast(nullif(nullif(lower("bdate"), 'null'), '0') AS varchar)))), '%Y-%m-%d')) As varchar))) IN ('6','7'))) )) LIMIT 5000000"
},
{
"id": "103",
"customer": "50",
"old": "SELECT DISTINCT goc.uuid FROM demosummit.go_customer_orc goc WHERE (bdate >= '{$date-7}' AND bdate < '{$date}') AND goc.uuid NOT IN ('0','1','2','3','4','5') AND (( (("interaction_type" IN (8))) AND (("interaction_value" IN (75,100))) )) ",
"new": "SELECT /* audience_id=103 */ DISTINCT goc.uuid FROM demosummit.go_customer_orc goc WHERE (bdate >= '{$date-7}' AND bdate <= '{$date}') AND goc.uuid NOT IN ('0','1','2','3','4','5') AND (( (("interaction_type" IN (8))) AND (("interaction_value" IN (75,100))) )) LIMIT 5000000"
},
!!! TRUNCATED !!!
],
"warnings": [
false,
false
]
},
"audit": {
"user": "Aaron Cox",
"user_id": "2189",
"cluster_id": "10",
"customer_id": "11"
},
"debug": {
"parsetime": "197,428.213835",
"now": "2018-02-13 04:09:29"
}
} |
Segment
Method
POST
Path
/audience-builder/segment
Usage
This endpoint is used to create segment for given integration id. Only Customers with admin rights can access this endpoint.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| integration_id | number | Y | |
| title | string | Y |
Example cURL
| Code Block |
|---|
curl -X POST \
'https://platform.flxone.com/api/audience-builder/segment?integration_id=1234&title=My%20Segment' \
-H 'Cache-Control: no-cache' \
-H 'X-Auth: es5a88dmlpktb5t6k9eifm6Pqjd0l70otkm1p2dv6g13h3h2thkptomb3k8dqe3ms3Xvorgr72h99uec0n92mf9hki9d23aprtsmds3' \
-H 'X-CSRF: 14f61670139eb434adf7f148bbea1a30' |
Output
| Code Block |
|---|
{ "response": { "status": "OK", "created": 11407460 }, "audit": { "user": "Aaron Cox", "user_id": "2189", "cluster_id": "10", "customer_id": "11" }, "debug } |
Segment
Method
POST
Path
/audience-builder/segment
Usage
This endpoint is used to create segment for given integration id. Only Customers with admin rights can access this endpoint.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| integration_id | number | Y | |
| title | string | Y |
Example cURL
| Code Block |
|---|
curl -X POST \
'https://platform.flxone.com/api/audience-builder/segment?integration_id=1234&title=My%20Segment' \
-H 'Cache-Control: no-cache' \
-H 'X-Auth: es5a88dmlpktb5t6k9eifm6Pqjd0l70otkm1p2dv6g13h3h2thkptomb3k8dqe3ms3Xvorgr72h99uec0n92mf9hki9d23aprtsmds3' \
-H 'X-CSRF: 14f61670139eb434adf7f148bbea1a30' |
Output
| Code Block |
|---|
{ "response": { "parsetimestatus": "1,716.529846OK", "nowcreated": "2018-02-13 04:15:57"11407460 } } |
Realtime Matching
Below is the list of requirements for Realtime Matching to be enabled and the errors that will be thrown if requirement is not met:
...