[Index]

API Reference for view/HcsLineReportVIEW

CREATE LINE REPORT Create a report of all lines configured at a site, indicating which lines are used by a device in another site ('Used Across Sites'). This information can be used to determine which lines might need to be moved if the site is to be deleted (thus deleting all lines within the site). The view also reports the hierarchy where the corresponding DN inventory is defined, whether the line is shared within the site, and the list of all devices referencing the line, who owns the device (in the case of phones), and the hierarchy of each device. When the report is executed, a new Line Report instance is created for each line in the site. Go to the list view of Line Reports to see the current list of line reports. This list can be sorted and filtered based on any criteria desired. For example, click on the 'Line Hierarchy' column to sort based on the site where the lines are defined, or click on the 'Used Across Sites' column to group lines based on whether they are used across sites. To avoid having too many line reports, delete the report instances when you are finished with them. You can delete them individually or delete a block of lines from the list view by clicking the checkbox in the column heading to select all instances in the list view, then click Delete.

Model ref.: view/HcsLineReportVIEW

The full URL would include the host-proxy name: https://[host-proxy].

Variables are enclosed in square brackets.

For a list of available UUIDs and their dot notations:
GET /api/v0/data/HierarchyNode/?format=json

Get the Add form

Task Call URL Parameters Response
Get the GUI Add form. GET /api/view/HcsLineReportVIEW/add/
  • hierarchy=[hierarchy]
  • format=json
 The GUI Add form of view/HcsLineReportVIEW as JSON

The API call to the /add/ URL can only be made from a hierarchy that allows the model type to be added. The actions in the response shows the url for the POST API call to create an instance.

Create

Task Call URL Parameters Payload
Create POST /api/view/HcsLineReportVIEW/ hierarchy=[hierarchy]
(For payload specification)

  • Response is a transaction pkid for the create action.

  • The GET call to 
    tool/Transaction/[trans pkid]
    shows the View resource has no instance pkid, because a view model stores no instances.

    • Bulk Export

    Task Call URL Parameters Payload
    Get a selected [export_format] of the schema and instances [pkid1], [pkid2],... of view/HcsLineReportVIEW; optionally with tag_version at [version] and Configuration Template as [configtemplate]. POST /api/view/HcsLineReportVIEW/export/
    • hierarchy=[hierarchy]
    • version=[version]
    • schema=
    • schema_rules=
    • template_name=[configtemplate]
    • export_format=[raw_xlsx|xlsx|json]
    		 { "hrefs":["/api/view/HcsLineReportVIEW/[pkid1]", "/api/view/HcsLineReportVIEW/[pkid2]",...]}}

    For export_format=json, the response is a time stamped zip file of data in JSON as in the system database. Item properties such as strings that are empty or Boolean values that are not set, are not included. The filename in the response is of the format as the example:

            Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip
        Content-Language:en
        Content-Type:application/x-zip

    For export_format=raw_xlsx, the response is a MS Excel spreadsheet with columns corresponding to the JSON format export and a response filename format:

            Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx
        Content-Language:en
        Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

    For export_format=xlsx, the response is a MS Excel spreadsheet, arranged by any Field Display Policies that apply. The columns correspond with those of a Bulk Load Template export sheet. The response filename format is:

            Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx
        Content-Language:en
        Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

    The XLSX format can be used to bulk load instances of view/HcsLineReportVIEW and the JSON format can be used to import instances of view/HcsLineReportVIEW.

    • To get the list of all instance pkids [pkid1],[pkid2], ..., use the List GET call for view/HcsLineReportVIEW: 
    •  GET http://[host-proxy]/api/view/HcsLineReportVIEW/?hierarchy=[hierarchy]

    Export Bulk Load Template

    Task Call URL Parameters Response
    Get a compressed format of the Bulk Load spreadsheet template for view/HcsLineReportVIEW POST /api/view/HcsLineReportVIEW/export_bulkload_template/
    • hierarchy=[hierarchy]
    • modeltype=view/HcsLineReportVIEW
    		 The response is an attachment of the format: filetype_bulkloadsheet.xlsx.gz

    List

    Task Call URL Parameters Response
    List GET /api/view/HcsLineReportVIEW/
    • hierarchy=[hierarchy]
    • format=json
    • schema=true
    		 The view/HcsLineReportVIEW schema and all instances as JSON.

    (The list will return 0 to 3 view/HcsLineReportVIEW instances)

    Help

    Task Call URL Parameters Response
    Get the on-line Help for view/HcsLineReportVIEW. GET /api/view/HcsLineReportVIEW/help hierarchy=[hierarchy] On-line help of Model ref.: view/HcsLineReportVIEW as HTML

    Instance API Reference

    Export

    Task Call URL Parameters Response
    Get a selected [export_format] of the schema and a single instance with [pkid] of view/HcsLineReportVIEW; optionally with tag_version at [version] and Configuration Template as [configtemplate]. GET /api/view/HcsLineReportVIEW/[pkid]/export/
    • hierarchy=[hierarchy]
    • version=[version]
    • schema=
    • schema_rules=
    • template_name=[configtemplate]
    • export_format=[raw_xlsx|xlsx|json]
    		 The response is an attachment. Refer to the list below.

    For export_format=raw_xlsx, the response is a "raw" MS Excel spreadsheet with columns corresponding to the JSON format export and a response format:

            Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx
        Content-Language:en
        Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

    For export_format=xlsx, the response is a MS Excel spreadsheet, formatted to show all columns and a response format:

            Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx
        Content-Language:en
        Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

    For export_format=json, the response is a time stamped zip file of data in JSON and a response format:

            Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip
        Content-Language:en
        Content-Type:application/x-zip

    The XLSX format can be used to bulk load instances of view/HcsLineReportVIEW and the JSON format can be used to import instances of view/HcsLineReportVIEW.

    For Bulk Export, refer to the Bulk Export section.

    Get

    Task Call URL Parameters Response
    Get GET /api/view/HcsLineReportVIEW/[pkid]/ hierarchy=[hierarchy] The view/HcsLineReportVIEW instance with [pkid].

    Help

    Task Call URL Parameters Response
    Help GET /api/view/HcsLineReportVIEW/[pkid]/help hierarchy=[hierarchy] The on-line Help for view/HcsLineReportVIEW.