guides:ws_payloads_get_repository_file_names

This is an old revision of the document!


payloads:get_repository_file_names

The payloads web service is a REST structured service that derives its functionality based on syntax used when calling the web service. When including the repository name in the payloads web service call, a list of file names will be returned along with the date the file was created, the lock status of the file, and the date the file was last modified. A variety of filters are available and are documented below.


Purpose: Get Payload File Names For Selected Repository

Request Endpoint

Method URL
GET https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads/{repository}?{filter}&page_size={page_size}&page={page_index}&order={order}

Variables:

Variable Usage Description
{repository} Required The name of the repository

Arguments:

Variable Usage Description
{filter} Optional Collection of {column_name}:{comparator}:{value} separated by ';' symbol.
{page_size} Optional A positive integer representing the number of items returned for a single page of results.
{page} Optional A positive integer representing the page index of the result set. First index is 0.
{order} Optional Sort order of the returned data. Format {column_name}:{sort_type}. Valid {sort_type) Ascending or Descending

Filter Usage:

Column Name Comparators Allowed Values
FILE_NAME Equals, Contains, StartsWith, EndsWith Any string data.
LOCK_STATUS Equals Locked, Unlocked, All
DATE_CREATED Equals, Greater, GreaterEqual, Less, LessEqual Any valid date in format MM-dd-yyyy
DATE_MODIFIED Equals, Greater, GreaterEqual, Less, LessEqual Any valid date in format MM-dd-yyyy

Request Body

N/A

Request Headers

Key Value
access_token {soft-token}

JSON Request Parameters

N/A

Notes:

Any condition that results in an unsuccessful call to the payloads web service will produce a JSON formatted response with a code and message property populated.

Sample Request

Endpoint:

https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads/processed? filter=date_created:GreaterEqual:7-28-2019;date_created:Less:8-31-2019;date_modified:GreaterEqual:8-25-2019;date_modified:Less:9-28-2019;file_name:Contains:test1;lock_status:Equal:Unlocked&page_size=10&page=1&order=Descending

Sample Response

Status Code: 200

{
    "result": [
        {
            "created": "2019-09-03 16:56:04",
            "file_name": "standard_user-033-190903161430419-00001.1.1_190903165601809",
            "lock_status": "Unlocked",
            "modified": "2019-09-03 16:56:18"
        },
        {
            "created": "2019-09-03 16:56:04",
            "file_name": "standard_user-033-190903161430419-00002.1.1_190903165601809",
            "lock_status": "Unlocked",
            "modified": "2019-09-03 16:56:23"
        },
        {
            "created": "2019-09-03 16:56:04",
            "file_name": "standard_user-033-190903161430419-00003.1.1_190903165601809",
            "lock_status": "Unlocked",
            "modified": "2019-09-03 16:56:24"
        },
        {
            "created": "2019-09-03 16:56:04",
            "file_name": "standard_user-033-190903161430419-00004.1.1_190903165601809",
            "lock_status": "Unlocked",
            "modified": "2019-09-03 16:56:17"
        },
        {
            "created": "2019-09-03 16:58:54",
            "file_name": "standard_user-033-190903161430419-00050.1.1_190903165852480",
            "lock_status": "Unlocked",
            "modified": "2019-09-03 16:59:08"
        }
    ]
}

OR

Status Code: 500 (When an error occurs.)

{
    "Exception": {
        "Code": "Undefined",
        "Message": "Invalid filter condition field name - \"lock_value\""
    }
}
guides/ws_payloads_get_repository_file_names.1598199720.txt.gz · Last modified: by brett.zamora