v2 Create Crosstab

POST

saved

crosstabs

curl --request POST \
  --url https://api.globalwebindex.com/v2/saved/crosstabs \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "uuid": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "name": "<string>",
  "rows": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "columns": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "country_codes": [
    "<string>"
  ],
  "wave_codes": [
    "<string>"
  ],
  "bases": {
    "id": "<string>",
    "name": "<string>",
    "full_name": "<string>",
    "avg": {
      "question": "q999",
      "with_suffixes": {
        "datapoint": "q999_99",
        "suffixes": [
          1,
          2
        ]
      },
      "with_datapoints": {
        "datapoints": [
          "q999_99"
        ]
      }
    },
    "expression": {
      "and": [
        {}
      ],
      "or": [
        {}
      ],
      "not": true,
      "qustion": "<string>",
      "options": [
        "<string>"
      ],
      "suffixes": [
        123
      ],
      "min_count": 123
    }
  },
  "last_updated_at": "2023-11-07T05:31:56Z",
  "notes": "<string>"
}'

{
  "uuid": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "name": "<string>",
  "user_id": 123,
  "org_id": "<string>",
  "rows": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "columns": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "country_codes": [
    "<string>"
  ],
  "wave_codes": [
    "<string>"
  ],
  "bases": {},
  "created_at": "2023-11-07T05:31:56Z",
  "updated_at": "2023-11-07T05:31:56Z",
  "notes": "<string>",
  "metadata": {}
}

Authorizations

Authorization

string

header

required

Body

application/json

Project to create

Project data.

uuid

string

Internal unique identifier for this project.

name

string

Name of project.

rows

object[]

Saved rows in the project.

Wrapper structure containing AudienceExpression

rows.id

string

rows.name

string

rows.full_name

string

rows.avg

object

Averages data for Platform

rows.avg.question

string

Example:

"q999"

rows.avg.with_suffixes

object

rows.avg.with_datapoints

object

rows.expression

object

Saved query for row or column

rows.expression.and

object[]

Saved query for row or column

rows.expression.or

object[]

Saved query for row or column

rows.expression.not

boolean

rows.expression.qustion

string

rows.expression.options

string[]

rows.expression.suffixes

number[]

rows.expression.min_count

integer

columns

object[]

Saved columns in the project.

Wrapper structure containing AudienceExpression

columns.id

string

columns.name

string

columns.full_name

string

columns.avg

object

Averages data for Platform

columns.avg.question

string

Example:

"q999"

columns.avg.with_suffixes

object

columns.avg.with_datapoints

object

columns.expression

object

Saved query for row or column

columns.expression.and

object[]

Saved query for row or column

columns.expression.or

object[]

Saved query for row or column

columns.expression.not

boolean

columns.expression.qustion

string

columns.expression.options

string[]

columns.expression.suffixes

number[]

columns.expression.min_count

integer

country_codes

string[]

List of saved country codes.

wave_codes

string[]

List of wave codes.

bases

object

Wrapper structure containing AudienceExpression

bases.id

string

bases.name

string

bases.full_name

string

bases.avg

object

Averages data for Platform

bases.avg.question

string

Example:

"q999"

bases.avg.with_suffixes

object

bases.avg.with_datapoints

object

bases.expression

object

Saved query for row or column

bases.expression.and

object[]

Saved query for row or column

bases.expression.or

object[]

Saved query for row or column

bases.expression.not

boolean

bases.expression.qustion

string

bases.expression.options

string[]

bases.expression.suffixes

number[]

bases.expression.min_count

integer

last_updated_at

string

The updated_at of this application or created_at of it's latest version

notes

string

Free-text field which user can enter notes in the UI

Response

200

application/json

Project data.

uuid

string

Internal unique identifier for this project.

name

string

Name of project.

user_id

integer

ID of user who created this project.

org_id

string

Organisation ID

rows

object[]

Saved rows in the project.

Wrapper structure containing AudienceExpression

rows.id

string

rows.name

string

rows.full_name

string

rows.avg

object

Averages data for Platform

rows.avg.question

string

Example:

"q999"

rows.avg.with_suffixes

object

rows.avg.with_datapoints

object

rows.expression

object

Saved query for row or column

rows.expression.and

object[]

Saved query for row or column

rows.expression.or

object[]

Saved query for row or column

rows.expression.not

boolean

rows.expression.qustion

string

rows.expression.options

string[]

rows.expression.suffixes

number[]

rows.expression.min_count

integer

columns

object[]

Saved columns in the project.

Wrapper structure containing AudienceExpression

columns.id

string

columns.name

string

columns.full_name

string

columns.avg

object

Averages data for Platform

columns.avg.question

string

Example:

"q999"

columns.avg.with_suffixes

object

columns.avg.with_datapoints

object

columns.expression

object

Saved query for row or column

columns.expression.and

object[]

Saved query for row or column

columns.expression.or

object[]

Saved query for row or column

columns.expression.not

boolean

columns.expression.qustion

string

columns.expression.options

string[]

columns.expression.suffixes

number[]

columns.expression.min_count

integer

country_codes

string[]

List of saved country codes. TODO explain

wave_codes

string[]

List of wave codes.

bases

object

Bases (audiences) for this project

created_at

string

The created_at of the project

updated_at

string

The updated_at of the project

notes

string

Free-text field which user can enter notes in the UI

metadata

object

Any metadata about this project, used by Platform

v2 Category Detail v2 Crosstab Detail

curl --request POST \
  --url https://api.globalwebindex.com/v2/saved/crosstabs \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "uuid": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "name": "<string>",
  "rows": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "columns": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "country_codes": [
    "<string>"
  ],
  "wave_codes": [
    "<string>"
  ],
  "bases": {
    "id": "<string>",
    "name": "<string>",
    "full_name": "<string>",
    "avg": {
      "question": "q999",
      "with_suffixes": {
        "datapoint": "q999_99",
        "suffixes": [
          1,
          2
        ]
      },
      "with_datapoints": {
        "datapoints": [
          "q999_99"
        ]
      }
    },
    "expression": {
      "and": [
        {}
      ],
      "or": [
        {}
      ],
      "not": true,
      "qustion": "<string>",
      "options": [
        "<string>"
      ],
      "suffixes": [
        123
      ],
      "min_count": 123
    }
  },
  "last_updated_at": "2023-11-07T05:31:56Z",
  "notes": "<string>"
}'

{
  "uuid": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "name": "<string>",
  "user_id": 123,
  "org_id": "<string>",
  "rows": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "columns": [
    {
      "id": "<string>",
      "name": "<string>",
      "full_name": "<string>",
      "avg": {
        "question": "q999",
        "with_suffixes": {
          "datapoint": "q999_99",
          "suffixes": [
            1,
            2
          ]
        },
        "with_datapoints": {
          "datapoints": [
            "q999_99"
          ]
        }
      },
      "expression": {
        "and": [
          {}
        ],
        "or": [
          {}
        ],
        "not": true,
        "qustion": "<string>",
        "options": [
          "<string>"
        ],
        "suffixes": [
          123
        ],
        "min_count": 123
      }
    }
  ],
  "country_codes": [
    "<string>"
  ],
  "wave_codes": [
    "<string>"
  ],
  "bases": {},
  "created_at": "2023-11-07T05:31:56Z",
  "updated_at": "2023-11-07T05:31:56Z",
  "notes": "<string>",
  "metadata": {}
}

Getting started

Use Cases

Transition from V1 to V2 API

Platform API

v2 Create Crosstab

Authorizations

Body

Response