Differences

This shows you the differences between two versions of the page.

--- guides:ws_payloads [2019/09/23 15:11] – brett.zamora
+++ guides:ws_payloads [2020/08/23 15:46] (current) – brett.zamora
@@ Line 1: / Line 1: @@
-==== Web Service: Payloads ====
+==== payloads:get_repository_names ====
+The payloads web service is a REST structured service that derives its functionality based on syntax used when calling the web service. In it's simplest form, with no parameters supplied, the payload service returns a list of supported repository names and a count of the number of payloads in each repository.
-The Payloads web service is a general purpose web service that derives its functionality based on syntax used when calling the web service. The following paragraphs outline the various functions and syntax supported by the Payloads web service.
+----
-Function: Get supported repository names with payload counts.
+**Purpose:** <color #22b14c>**Get Supported Repository Names With Payload Counts.**</color>
@@ Line 23: / Line 24: @@
 {{tablelayout?colwidth="150px,450px"&rowsFixed=1&rowsVisible=10&float=center}}
 ^ Key ^ Value ^
-| Content-Type | application/json |
 | access_token | {soft-token} |
@@ Line 29: / Line 29: @@
 <color #7092be>JSON Request Parameters</color>
-{{tablelayout?colwidth="150px,75px,100px,275px"&rowsFixed=1&rowsVisible=10&float=center}}
+N/A
-^ Parm Name ^ Req/Opt ^ Format ^ Description ^
-| checksum_key | Required | [string] | The checksum key of a checksum record stored in the CeRTNA Portal. |
-| checksum | Required | [string] | Locally calculated binary checksum value converted to a Base64 string. |
-<color #7092be>JSON Response Parameters</color>
-{{tablelayout?colwidth="125px,100px,375px"&rowsFixed=1&rowsVisible=10&float=center}}
-^ Parm Name ^ Format ^ Description ^
-| is_valid | [string] | True if checksum values match, otherwise false. |
-| code | [string] | Exception conditions will result in code/message being returned. |
-| message | [string] | Longer description of exception condition. |
+**Notes:**
-As noted, any condition that results in an unsuccessful call to the ValidateChecksum web service will produce a JSON formatted response with a code and message property populated.
+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.
@@ Line 50: / Line 40: @@
 **Endpoint:**
-<nowiki>https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/validatechecksum</nowiki>
+<nowiki>https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads</nowiki>
-**Headers:**
+<color #7092be>Sample Response</color>
-Content-Type: application/json
+Status Code: 200
-**Body:**
+<code json>
+[
+    {
+        "Count": 0,
+        "RepositoryName": "Responses"
+    },
+    {
+        "Count": 0,
+        "RepositoryName": "Requests"
+    },
+    {
+        "Count": 96,
+        "RepositoryName": "Processed"
+    },
+    {
+        "Count": 0,
+        "RepositoryName": "Invalid"
+    }
+]
+</code>
+**OR**
+Status Code: 500  (When an error occurs.)
 <code json>
 {
-  "checksum_key" : "D6D5895C-60BF-4D21-AE5B-945C8E255665",
+    "Exception": {
-  "checksum" : "1/l1YnJ1dnWFVbjEcUfp3IkBkPb1XBWhdC34T6nJ3YB859YuAtbhUUEG8Gcwimd1"
+        "Code": "InvalidUserCredentials",
+        "Message": "Invalid Session Id"
+    }
 }
 </code>
+----
+**FUNCTION:** <color #22b14c>**Get Payload File Names For Selected Repository**</color>
+<color #7092be>Request Endpoint</color>
+{{tablelayout?colwidth="75px,575px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ Method ^ URL ^
+| GET | <nowiki>https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads/{repository}?{filter}&page_size={page_size}&page={page_index}&order={order}</nowiki> |
+**Variables:**
+{{tablelayout?colwidth="100px,75px,475px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ Variable ^ Usage ^ Description ^
+| {repository} | Required | The name of the repository |
+**Arguments:**
+{{tablelayout?colwidth="100px,75px,475px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ 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:**
+{{tablelayout?colwidth="150px,250px,250px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ 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 |
+<color #7092be>Request Body</color>
+N/A
+<color #7092be>Request Headers</color>
+{{tablelayout?colwidth="150px,450px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ Key ^ Value ^
+| access_token | {soft-token} |
+<color #7092be>JSON Request Parameters</color>
+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.
+<color #7092be>Sample Request</color>
+**Endpoint:**
+<nowiki>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</nowiki>
@@ Line 75: / Line 159: @@
 <code json>
 {
-    "is_valid": "true"
+    "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"
+        }
+    ]
 }
 </code>
@@ Line 84: / Line 199: @@
 Status Code: 500  (When an error occurs.)
+<code json>
+{
+    "Exception": {
+        "Code": "Undefined",
+        "Message": "Invalid filter condition field name - \"lock_value\""
+    }
+}
+</code>
-(example 1)
+**FUNCTION:** <color #22b14c>**Retrieve A Payload From A Repository**</color>
+<color #7092be>Request Endpoint</color>
+{{tablelayout?colwidth="75px,575px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ Method ^ URL ^
+| GET | <nowiki>https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads</nowiki> |
+<color #7092be>Request Body</color>
+N/A
+<color #7092be>Request Headers</color>
+{{tablelayout?colwidth="150px,450px"&rowsFixed=1&rowsVisible=10&float=center}}
+^ Key ^ Value ^
+| access_token | {soft-token} |
+<color #7092be>JSON Request Parameters</color>
+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.
+<color #7092be>Sample Request</color>
+**Endpoint:**
+<nowiki>https://apex-prd.certna.org/APEX/Service/APEXPublicServer.svc/payloads</nowiki>
+<color #7092be>Sample Response</color>
+Status Code: 200
+<code json>
+[
+    {
+        "Count": 0,
+        "RepositoryName": "Responses"
+    },
+    {
+        "Count": 0,
+        "RepositoryName": "Requests"
+    },
+    {
+        "Count": 96,
+        "RepositoryName": "Processed"
+    },
+    {
+        "Count": 0,
+        "RepositoryName": "Invalid"
+    }
+]
+</code>
+**OR**
+Status Code: 500  (When an error occurs.)
 <code json>
 {
     "Exception": {
-        "Code": "DatabaseError",
+        "Code": "InvalidUserCredentials",
-        "Message": "Conversion failed when converting from a character string to uniqueidentifier."
+        "Message": "Invalid Session Id"
     }
 }
 </code>
+----