_getDT

Gathers data about Marketing Expenses and their linked Sources, filtered within a period of time:

• The ID of the Expense

• The ID of the Marketing Source linked to the retrieved Expense

• The cost of the Expense

• The date of the Expense

Parameters

draw

A number which is echoed back to the caller. Useful for avoiding race conditions.

start

The number of entries skipped before the function starts retrieving Expenses.

length

The number of entries returned, if the "start" parameter is higher than 0, skipped entries are not included.

dateFrom

The earliest date where Marketing Expenses are valid to be retrieved (relates to the current date, e.g 2 days ago would be "-2")

dateTo

The latest date where Marketing Expenses are valid to be retrieved (relates to the current date, e.g an exact week later than today would be "7")

Examples

For these examples: The function is called on 30th May, 2023. start = 0, length = 10, dateFrom = 10, dateTo = 31

FM_api(
    'MarketingExpenses_getDT',[
      'draw' => 1,
      'start' => 0,
      'length' => 10,
      'dateFrom' => 10,
      'dateTo' => 31
    ]
);

Result:

{
    "data":[
        ["18","11",4,"19-06-2023",""]
    ],
"draw":1,"recordsTotal":"3","recordsFiltered":"1"
}

In this example: start = 0, length = 10, dateFrom = -2, dateTo = 14

FM_api(
    'MarketingExpenses_getDT',[
      'draw' => 2,
      'start' => 0,
      'length' => 10,
      'dateFrom' => -2,
      'dateTo' => 14
    ]
);

Result:

{
    "data":[
        ["17","7",31,"31-05-2023",""],
        ["18","11",4,"19-06-2023",""]
    ],
    "draw":2,"recordsTotal":"3","recordsFiltered":"2"
}

On Failure

If the "draw" parameter is not set

{"error":"missing or invalid parameter: draw"}