Forum Discussion

KOK's avatar
KOK
New Member
3 years ago

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]

          

 

 

 

 

 

No RepliesBe the first to reply