To export items search results as xlsx, us command core/export_file:
svc=core/export_file¶ms={"spec":{ "itemsType":<text>, "propName":<text>, "propValueMask":<text>, "sortType":<text> }, "force":<uint>, "flags":<long> /* columns flags */ }
Description of other params you can see on page Search items by property
Flags
Value | Description |
---|---|
For “itemsType” | “user” |
0x0001 | Name |
0x0002 | Creator |
0x0004 | Account |
0x0008 | Billing plan |
0x0010 | Last visit |
For “itemsType” | “avl_unit” |
0x0001 | Name |
0x0002 | Creator |
0x0004 | Account |
0x0008 | Device type |
0x0010 | UID |
0x0020 | Phone |
0x0040 | Last message |
0x0080 | Created |
0x0100 | Custom fields |
For “itemsType” | “avl_unit_group” |
0x0001 | Name |
0x0002 | Creator |
0x0004 | Account |
0x0008 | Units |
For “itemsType” | “avl_resource” |
0x0001 | Name |
0x0002 | Creator |
0x0004 | Parent account |
0x0008 | Billing plan |
0x0010 | Dealer rights |
0x0020 | Units |
0x0040 | Balance |
0x0080 | Days |
0x0100 | Status |
0x0200 | Blocked |
Response
Returns .xlsx file.