Skip to content

[Content] Request examples

Juan Gabriel Griggio edited this page May 9, 2024 · 1 revision
  • POST /content?destination=dv360feed&first-term-source=spreadsheet&second-term-source=google_trends&must-find-relationship=true
{
    "num_headlines": 10,
    "num_descriptions": 10,
    "first_term_source_config" : {
        "spreadsheet_id": "My products spreadsheet id",
        "sheet_name": "My products sheet name",
        "starting_row": 2,
        "term_column": "A",
        "term_description_column": "B"
    },
    "second_term_source_config" : {
        "limit": 10
    },
    "destination_config" : {
        "spreadsheet_id": "My output spreadsheet id",
        "sheet_name": "My output sheet name"
    },
    "headlines_blacklist": [
      "Unisex",
      "Cheap",
      "Free"
    ],
    "descriptions_blacklist": [
      "Get free",
    ]
}
  • POST /content?destination=acsfeed&first-term-source=big_query&second-term-source=search_scout&must-find-relationship=true
{
    "num_headlines": 5,
    "num_descriptions": 5,
    "first_term_source_config" : {
        "project_id": "My project id",
        "dataset": "My dataset",
        "table": "My table",
        "term_column": "product_title",
        "term_description_column": "product_description",
        "limit": 10
    },
    "second_term_source_config" : {
        "project_id": "My project id",
        "dataset": "My dataset",
        "table": "My table",
        "term_column": "product_title",
        "limit": 10
    },
    "destination_config" : {
        "spreadsheet_id": "My output spreadsheet id",
        "sheet_name": "My output sheet name",
        "variant_name_column": "B",
        "constant_columns": ["E"],
        "copies_columns": ["C", "D"],
        "starting_row": 2
    },
    "headlines_regexp_blacklist": [
      "[AZ]+"
    ]
}
  • POST /content?destination=sa360feed&first-term-source=big_query
{
    "num_headlines" : 3,
    "num_descriptions" : 3,
    "first_term_source_config" : {
        "query": "SELECT title AS term, description, product_id AS sku FROM `project.dataset.table` SORT BY title DESC LIMIT 10"
    },
    "destination_config" : {
        "spreadsheet_id": "My output spreadsheet id",
        "sheet_name": "My output sheet name"
    }
}