Pull information from Api of sip server to get database for calls in excel or csv file the information have to be grouped by subscribers i have access to Api with certificates of administrator.

Pull information from Api of sip server to get database for calls in excel or csv file the information have to be grouped by subscribers. CallLists Description Defines call lists in simplified form for showing call histories of subscribers. Collection Actions Allowed methods for the collection as in METHOD /api/calllists/: HEAD OPTIONS GET Item Actions Allowed methods for a collection item as in METHOD /api/calllists/id: HEAD GET OPTIONS Properties call_id (String): The internal SIP Call-ID of the call. customer_cost (null, Number): The cost for the customer. customer_free_time (null, Number): The number of free seconds of the customer used for this call. direction ('in'|'out'): Call direction, either "in" or "out" duration (Number): The duration of the call. intra_customer (Boolean): Whether it is a call between subscribers of one single customer. other_cli (null, String): The CLI of the other party, or null if CLIR was active. For intra-PBX calls it is the PBX extension, for inter-PBX calls it is the value of the field specified by the alias_field parameter if available, otherwise the souce_cli or destination_user_in. CLI format is denormalized by caller-out rewrite rule of subscriber. own_cli (String): The CLI of the own party. For PBX subscribers it is always the PBX extension, otherwise the source_cli or destination_user_in. CLI format is denormalized by caller-out rewrite rule of subscriber. rating_status ('ok'|'unrated'|'failed'): The status of the call rating, one of ok, unrated, failed. start_time (String): The timestamp of the call connection. status ('ok'|'busy'|'noanswer'|'cancel'|'offline'|'timeout'|'other'): The status of the call, one of ok, busy, noanswer, cancel, offline, timeout, other. total_customer_cost (null, Number): Total cost for the customer. VAT is included if applicable. type ('call'|'cfu'|'cfb'|'cft'|'cfna'): The type of call, one of call, cfu, cfb, cft, cfna. Query Parameters tz: Format start_time according to the optional time zone provided here, e.g. Europe/Berlin. subscriber_id: Filter for calls for a specific subscriber. Either this or customer_id is mandatory if called by admin, reseller or subscriberadmin to filter list down to a specific subscriber in order to properly determine the direction of calls. customer_id: Filter for calls for a specific customer. Either this or subscriber_id is mandatory if called by admin, reseller or subscriberadmin to filter list down to a specific customer. For calls within the same customer_id, the direction will always be "out". alias_field: Set this parameter for example to "gpp0" if you store alias numbers in the gpp0 preference and want to have that value shown as other CLI for calls from or to such a local subscriber. status: Filter for calls with a specific status. One of "ok", "busy", "noanswer", "cancel", "offline", "timeout", "other". status_ne: Filter for calls not having a specific status. One of "ok", "busy", "noanswer", "cancel", "offline", "timeout", "other". rating_status: Filter for calls having a specific rating status. Comma separated list of "ok", "unrated", "failed". rating_status_ne: Filter for calls not having a specific rating status. Comma separated list of "ok", "unrated", "failed". type: Filter for calls with a specific type. One of "call", "cfu", "cfb", "cft", "cfna". type_ne: Filter for calls not having a specific type. One of "call", "cfu", "cfb", "cft", "cfna". direction: Filter for calls with a specific direction. One of "in", "out". start_ge: Filter for calls starting greater or equal the specified time stamp. start_le: Filter for calls starting lower or equal the specified time stamp. order_by: Order collection by a specific attribute. Possible values are: id, update_time, source_user_id, source_provider_id, source_external_subscriber_id, source_external_contract_id, source_account_id, source_user, source_domain, source_cli, source_clir, source_ip, source_gpp0, source_gpp1, source_gpp2, source_gpp3, source_gpp4, source_gpp5, source_gpp6, source_gpp7, source_gpp8, source_gpp9, destination_user_id, destination_provider_id, destination_external_subscriber_id, destination_external_contract_id, destination_account_id, destination_user, destination_domain, destination_user_dialed, destination_user_in, destination_domain_in, destination_gpp0, destination_gpp1, destination_gpp2, destination_gpp3, destination_gpp4, destination_gpp5, destination_gpp6, destination_gpp7, destination_gpp8, destination_gpp9, peer_auth_user, peer_auth_realm, call_type, call_status, call_code, init_time, start_time, duration, call_id, source_carrier_cost, source_reseller_cost, source_customer_cost, source_carrier_free_time, source_reseller_free_time, source_customer_free_time, source_carrier_billing_fee_id, source_reseller_billing_fee_id, source_customer_billing_fee_id, source_carrier_billing_zone_id, source_reseller_billing_zone_id, source_customer_billing_zone_id, destination_carrier_cost, destination_reseller_cost, destination_customer_cost, destination_carrier_free_time, destination_reseller_free_time, destination_customer_free_time, destination_carrier_billing_fee_id, destination_reseller_billing_fee_id, destination_customer_billing_fee_id, destination_carrier_billing_zone_id, destination_reseller_billing_zone_id, destination_customer_billing_zone_id, frag_carrier_onpeak, frag_reseller_onpeak, frag_customer_onpeak, is_fragmented, split, rated_at, rating_status, exported_at, export_status order_by_direction: Direction which the collection should be ordered by. Possible values are: asc (default), desc