Differences
This shows you the differences between two versions of the page.
|
|
|
en:sidebar:remoteapi:apiref:core:export_file [27/07/2016 16:27]
stan [Export of items search result as xlsx] |
en:sidebar:remoteapi:apiref:core:export_file [06/06/2018 06:57]
|
| ====== Export of items search result as xlsx ====== | |
| |
| To export items search results as xlsx, us command **core/export_file**: | |
| <code javascript> | |
| svc=core/export_file¶ms={"spec":{ | |
| "itemsType":<text>, | |
| "propName":<text>, | |
| "propValueMask":<text>, | |
| "sortType":<text> | |
| }, | |
| "force":<uint>, | |
| "flags":<long> /* columns flags */ | |
| } | |
| </code> | |
| |
| :!: Description of other params you can see on page [[search_items|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. | |
