foxtrot-api.onemarketing.dk Open in urlscan Pro
185.45.186.7  Public Scan

Form analysis
0 forms found in the DOM

Text Content

ONE Simple API  version 2.0.10
The "ONE Simple API" provides an API to insert, update, read and delete data in
a database. Each operation is specified using either JSON or XML and requires a
key in the function call. Only customers at ONE Marketing can request a key and
get access to the API.
Both GET or POST are supported but GET should only be used for testing purposes.
Show XML options
Insert or update data

Syntax: upsert.aspx?key=<your key>&json=<input json> Comment Insert or update
one or more rows in the database. Both key and json are required. If the upsert
contains multiple rows, the insert and updates are executed as a single
transaction.
The JSON for inserting into (or updating data in) one or more tables consists of
a list of one or more rows to insert or update in a table. A row has one or more
fields to be inserted or updated. When inserting, the key attribute should be
false for all fields. When updating, min one key field is required and only
non-key fields are updated. Input JSON: [
  {
    "target": "<table name>",
    "action": "insert|update",
    "fields": [
      {
        "name": "<column name>",
        "type": "numeric|text|datetime",
        "key": "true|false",
        "value": "<value>"
      }
    ]
  }
]


Fetch data

Syntax: fetch.aspx?key=<your key>&json=<input json> Comment Retrieve the content
of a table/view from the database. The select must have at least one condition.
Both key and json are required. Input JSON: {
  "source": "<table name>",
  "conditions": [
    {
      "column": "<column name>",
      "type": "numeric|text|datetime",
      "operator": "<|>|=|is null|is not null",
      "value": "<value>"
    }
  ]
} Output JSON: {
  "count": <row count>,
  "rows": [
    [
      {
        "column": "<column name>",
        "type": "numeric|text|datetime",
        "value": "<value>"
      }
    ]
  ]
}


Delete data

Syntax: delete.aspx?key=<your key>&json=<input json> Comment Deletes the content
from a table in the database. The select must have at least one condition. Both
key and json are required. Input JSON: {
  "target": "<table name>",
  "conditions": [
    {
      "column": "<column name>",
      "type": "numeric|text|datetime",
      "operator": "<|>|=|is null|is not null",
      "value": "<value>"
    }
  ]
}


Execute procedure

Syntax: execute.aspx?key=<your key>&return=<xml|json>&function=<function to
execute>&<p1>=<value of p1>&<p2>=<value of p2> Comment Executes a database
procedure with zero, one or more text based parameters. The p1, p2, etc are
parameters for the procedure and can be named as needed. Notice that key,
function and return are reserved words and can not be used as parameter names.


Query tables

Syntax: query.aspx?key=<your key>&format=<xml|json>&table=<table name> Comment
Get table/view column definitions. If no table is given, a list of all tables
are returned. Parameter format defines which format is used for table listing.
Only 'xml' and 'json' is supported. The key and format are required while the
table is optional.  Returns: <XML or JSON dataset>


Key Table




ONE Marketing 2018