_getDT

Returns details of Opportunities based on search and a selected date period:

Parameters

start

The number of Opportunities skipped before this function begins to return results.

length

The number of Opportunity results which will be returned

search[value]

A string value which will filter out any Opportunities which do not include the string within.

order[column]

The topic which will be used to order the given results.

order[dir]

Displays the results in ascending or descending order, based on a topic chosen by the "column" parameter. ("asc" or "desc")

dateFrom

The earliest number of days before, which results will be returned from. (Relative to the day this function is used, e.g "-7" will return results as old as a week before the current date)

dateTo

The most recent day which results will be returned from.

draw

A value to determine the most recent execution of this function, increases by 1 every use, highest number being the most recent use of this function.

Example

FM_api('Opportunities_getDT', [
    'draw' => '0',
    'order' => [
        [
            [
            'column' => '0',
            'dir' => 'asc'
            ]
        ]
    ],
    'start' => '0',
    'length' => '10',
    'search' => [
            'value' => ''
            ],
    'dateFrom' => '-30',
    'dateTo' => '0'
    ]
);

On Success

{"data":[["60007","1714921557","460775","92447","712758","3","",[null,null],"1","7",null,"",""],["60008","1714921504","490443","92447","712758","0","waldjkvns",[null,null],"1","7",null,"",""],["60009","1714921512","460775","92447","712758","0","wadgkvj",[null,null],"1","7",null,"",""]],"draw":1,"recordsTotal":9,"recordsFiltered":3}