GetAllActivitiesWithCustomCols
Function returns all activities with custom fields
https://rest.crmango.com/api/GetAllActivitiesWithCustomCols
Authorization
1
Sent in the request headers
Bearer
varchar
Auth token
Body data
5
Sent in the request body
date_from
timestamp
Date from
date_to
timestamp
Date to
date_type
varchar
Date type to filter data by.
Options: created_at or updated_at
page
integer
Pagination of results (default is 0)
limit
integer
Limit of results per page (Max si 10000)
Response
28
HTTP 200
Function returns all activities with custom fields
id
integer
Activity id
note
text
Activity note
timefrom
integer
Time from
timeto
integer
Time to
date
varchar
Date
source
varchar
Source name
type_id
integer
Activity type id
userid
integer
Activity user
company_id
integer
The company to which the activity belongs
orderid
integer
Order id. If you want to connect activity and order.
person_id
integer
Company person id
readonly_record
boolean
Readonly
verified_record
boolean
If it is verified by the user. 0-unverified, 1-verified, 2-declined, 3-without verifitacion.
source_id
varchar
Source id. Id of 3th gen system. For example ID of record in other system.
to_report
integer
Show activity in the report. 1/0
my_company
integer
My company ID.
order_code
varchar
Order code
software_id
integer
Software id
source_direction
varchar
Source direction. IN/OUT
company_name
varchar
Company name
unassigned
varchar
Unassigned. Email or telephone number, when you do not know whether the record is in the address book.
next_activity
integer
Date of next activity
updated_at
timestamp
Date of activity update
custom_fields[][id_activity]
integer
Activity id
custom_fields[][id_own_activity]
integer
Own activity id
custom_fields[][id_input]
integer
Input id
custom_fields[][data_type]
varchar
Data type
custom_fields[][data]
varchar
Data in input
Example request
curl --request POST \
--url 'https://rest.crmango.com/api/GetAllActivitiesWithCustomCols' \
--header 'Authorization: Bearer auth_token' \
--header 'Content-Type: application/json' \
--data '{
"date_from": "timestamp",
"date_to": "timestamp",
"date_type": "varchar",
"page": "integer",
"limit": "integer"
}'$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://rest.crmango.com/api/GetAllActivitiesWithCustomCols',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"date_from": "timestamp",
"date_to": "timestamp",
"date_type": "varchar",
"page": "integer",
"limit": "integer"
}',
CURLOPT_HTTPHEADER => array(
'Authorization: Bearer auth_token',
'Content-Type: application/json'
),
));
$response = curl_exec($curl);
echo $response;var data = JSON.stringify({
"date_from": "timestamp",
"date_to": "timestamp",
"date_type": "varchar",
"page": "integer",
"limit": "integer"
});
var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
xhr.addEventListener("readystatechange", function () {
if (this.readyState === 4) {
console.log(this.responseText);
}
});
xhr.open("POST", "https://rest.crmango.com/api/GetAllActivitiesWithCustomCols");
xhr.setRequestHeader("Authorization", "Bearer auth_token");
xhr.setRequestHeader("Content-Type", "application/json");
xhr.send(data);import requests
import json
url = "https://rest.crmango.com/api/GetAllActivitiesWithCustomCols"
payload = json.dumps({
"date_from": "timestamp",
"date_to": "timestamp",
"date_type": "varchar",
"page": "integer",
"limit": "integer"
})
headers = {
'Authorization': 'Bearer auth_token',
'Content-Type': 'application/json'
}
response = requests.request("POST", url, headers=headers, data=payload)
print(response.text){
"code": 200,
"response": [
{
"id": 1242,
"note": "",
"timefrom": 1569826800,
"timeto": 1569826800,
"date": 1569794400,
"source": "",
"type_id": 7,
"userid": 7,
"company_id": 0,
"orderid": 0,
"person_id": 0,
"readonly_record": 0,
"verified_record": 1,
"source_id": 0,
"to_report": 1,
"my_company": 0,
"order_code": "",
"software_id": 0,
"source_direction": "",
"company_name": "",
"unassigned": "",
"next_activity": 0,
"updated_at": 1569826800,
"custom_fields": [
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 2,
"data_type": "text",
"data": "45765434567"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 3,
"data_type": "number",
"data": "123"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 4,
"data_type": "checkbox",
"data": "1"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 5,
"data_type": "date",
"data": "1655935200"
}
]
},
{
"id": 2232,
"note": "",
"timefrom": 1569826950,
"timeto": 1569827150,
"date": 1569794400,
"source": "",
"type_id": 1,
"userid": 1,
"company_id": 0,
"orderid": 0,
"person_id": 0,
"readonly_record": 0,
"verified_record": 1,
"source_id": 0,
"to_report": 1,
"my_company": 0,
"order_code": "",
"software_id": 0,
"source_direction": "",
"company_name": "",
"unassigned": "",
"next_activity": 0,
"updated_at": 1569826800,
"custom_fields": [
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 2,
"data_type": "text",
"data": "45765434567"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 3,
"data_type": "number",
"data": "123"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 4,
"data_type": "checkbox",
"data": "1"
},
{
"id_activity": 9484,
"id_own_activity": 1,
"id_input": 5,
"data_type": "date",
"data": "1655935200"
}
]
},
{
"id": 5658,
"note": "SK, 972 01 Bojnice",
"timefrom": 1644316065,
"timeto": 1644318602,
"date": 1644403814,
"source": "GPS tracker",
"type_id": 4,
"userid": 1,
"company_id": 0,
"orderid": 0,
"person_id": 0,
"readonly_record": 1,
"verified_record": 3,
"source_id": 1539088026,
"to_report": 1,
"my_company": 0,
"order_code": "",
"software_id": 0,
"source_direction": "",
"company_name": "",
"unassigned": "",
"next_activity": 0,
"updated_at": 1569826800
}
]
}
{
"code": "int",
"message": "string"
}