KOK
3 years agoNew Member
API DOCUMENTATION : ORACLE APEX PAGE: NOT ABLE TO FETCH DATA -'401'
Trying to get '200' after executing the "GET" request.
REST SERVICE
ERROR
but getting error '401'.
COMPLETE CODE
openapi: 3.0.1
servers:
- url: https://hzq888dfk8i4pwv-bidwdev1.adb.us-ashburn-1.oraclecloudapps.com/ords/dw/customers
info:
version: "1.0.0"
title: API FOR CUSTOMER DATA RETRIVAL
description : >-
Customer data extraction
paths:
/Customer_data:
get:
description: Retrieve records from Customer
responses:
'200':
description: The queried record.
content:
application/json:
schema:
type: object
properties:
items:
type: array
items:
type: object
properties:
accountname:
$ref: '#/components/schemas/VARCHAR2'
accountref:
$ref: '#/components/schemas/VARCHAR2'
active:
$ref: '#/components/schemas/VARCHAR2'
companykeygoldenlevel1:
$ref: '#/components/schemas/VARCHAR2'
companynamegoldenlevel1:
$ref: '#/components/schemas/VARCHAR2'
customertype:
$ref: '#/components/schemas/VARCHAR2'
id:
$ref: '#/components/schemas/VARCHAR2'
legalentitycodelevel3:
$ref: '#/components/schemas/VARCHAR2'
legalentitynamelevel3:
$ref: '#/components/schemas/VARCHAR2'
marketsegment1:
$ref: '#/components/schemas/VARCHAR2'
parentcodelevel2:
$ref: '#/components/schemas/VARCHAR2'
parentnamelevel2:
$ref: '#/components/schemas/VARCHAR2'
sproperty:
$ref: '#/components/schemas/VARCHAR2'
total_count:
$ref: '#/components/schemas/NUMBER'
'400':
description: BAD REQUEST
'401':
description: SIGN IN REQUIRED
'403':
description: FORBIDDEN
'404':
description: PAGE NOT FOUND
'405':
description: METHOD NOT ALLOWED
'426':
description: UPGRADE REQUIRED
'500':
description: INTERNAL SERVER ERROR
'503':
description: Service unavailable
/total_count:
get:
description: Retrieve total count from Customers
responses:
'200':
description: The queried record.
content:
application/json:
schema:
type: object
properties:
items:
type: array
items:
type: object
properties: {}
components:
securitySchemes:
oAuthSample:
type: oauth2
description: This API uses Oauth 2 with the implicit grant flow.
flows:
implicit:
authorizationUrl: https://hzq888dfk8i4pwv-bidwdev1.adb.us-ashburn-1.oraclecloudapps.com/ords/dw/customers
scopes:
write: allows modifying resources
read: allows reading resources
schemas:
NUMBER:
type: number
VARCHAR2:
type: string
security:
- oAuthSample: [write,read]