Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Swagger JSON Parse Error

Chad BoomAug 15 2019 — edited Aug 22 2019

When generating swagger output, we are getting a json parse error. We just upgraded to ords 19.1. Below is some supporting information. Any help you can provide would be greatly appreciated.

https://xxxxxxxxxx/open-api-catalog/inventory/

pastedImage_3.png

pastedImage_4.png

pastedImage_0.png

pastedImage_2.png

{"swagger":"2.0","info":{"title":"ORDS generated API for Inventory Services","version":"1.0.0"},"host":"ords1dev.sficorp.com","basePath":"/ords/invio/xxords/inventory","schemes":["http"],"produces":["application/json"],"paths":{"/accountNumberList":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/adjustunit":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"quantity","in":"header","type":"string","required":true},{"name":"reasonCode","in":"header","type":"string","required":true},{"name":"secondaryQuantity","in":"header","type":"string","required":true},{"name":"unitId","in":"header","type":"string","required":true},{"name":"unitOfMeasure","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/combineUnits":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"message":"status"

Error: Parse error on line 1: ...:{"message":"status":}}}},"parameters":[ -----------------------^ Expecting 'EOF', '}', ',', ']'

:}}}},"parameters":[{"name":"payload","in":"body","required":true,"schema":{"$ref":"#/definitions/PAYLOAD1"}}]}},"/createPalletTransaction":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"payload","in":"body","required":true,"schema":{"$ref":"#/definitions/PAYLOAD2"}}]}},"/createtestinventory":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"message":"status":"unitList":}}}},"parameters":[{"name":"payload","in":"body","required":true,"schema":{"$ref":"#/definitions/PAYLOAD3"}}]}},"/dcsummarylist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"export","in":"header","type":"string","required":true},{"name":"inventoryType","in":"header","type":"string","required":true},{"name":"locationFrom","in":"header","type":"string","required":true},{"name":"locationTo","in":"header","type":"string","required":true},{"name":"locationType","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/directputawaylist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"export","in":"header","type":"string","required":true},{"name":"itemType","in":"header","type":"string","required":true},{"name":"rackAisleFrom","in":"header","type":"string","required":true},{"name":"rackAisleTo","in":"header","type":"string","required":true},{"name":"rackBinFrom","in":"header","type":"string","required":true},{"name":"rackBinTo","in":"header","type":"string","required":true},{"name":"rackLevelFrom","in":"header","type":"string","required":true},{"name":"rackLevelTo","in":"header","type":"string","required":true},{"name":"transactionDateFrom","in":"header","type":"string","required":true},{"name":"transactionDateTo","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true},{"name":"warehouse","in":"header","type":"string","required":true}]}},"/discrepancyList":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"inventoryDiscrepList":{"$ref":"#/definitions/RESULTSET"},"messageReturn":"statusReturn":}}}},"parameters":[{"name":"expirationDateDisc","in":"query","type":"string","description":"Implicit parameter"},{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemType","in":"query","type":"string","description":"Implicit parameter"},{"name":"limit","in":"query","type":"string","description":"Implicit parameter"},{"name":"lotNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"makeDateDisc","in":"query","type":"string","description":"Implicit parameter"},{"name":"offset","in":"query","type":"string","description":"Implicit parameter"},{"name":"primaryQtyDisc","in":"query","type":"string","description":"Implicit parameter"},{"name":"stockLocator","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/history":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"inventoryHistoryList":{"$ref":"#/definitions/RESULTSET"},"messageReturn":"statusReturn":}}}},"parameters":[{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"limit","in":"query","type":"string","description":"Implicit parameter"},{"name":"locationName","in":"query","type":"string","description":"Implicit parameter"},{"name":"offset","in":"query","type":"string","description":"Implicit parameter"},{"name":"palletCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"appointmentId","in":"header","type":"string","required":true},{"name":"batchNumber","in":"header","type":"string","required":true},{"name":"cartId","in":"header","type":"string","required":true},{"name":"dateFrom","in":"header","type":"string","required":true},{"name":"dateTo","in":"header","type":"string","required":true},{"name":"invType","in":"header","type":"string","required":true},{"name":"itemCode","in":"header","type":"string","required":true},{"name":"loadId","in":"header","type":"string","required":true},{"name":"lotNumber","in":"header","type":"string","required":true},{"name":"orderNumber","in":"header","type":"string","required":true},{"name":"org","in":"header","type":"string","required":true},{"name":"receiptOrderNumber","in":"header","type":"string","required":true},{"name":"transType","in":"header","type":"string","required":true},{"name":"unitId","in":"header","type":"string","required":true},{"name":"unitOfMeasure","in":"header","type":"string","required":true},{"name":"userId","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/inventorytypelist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"locationName","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/itemDemandList":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"appointmentType","in":"query","type":"string","description":"Implicit parameter"},{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/itemDemandTotalsList":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"appointmentType","in":"query","type":"string","description":"Implicit parameter"},{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/iteminfo":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"export","in":"header","type":"string","required":true},{"name":"itemId","in":"header","type":"string","required":true},{"name":"limit","in":"header","type":"string","required":true},{"name":"offset","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/list":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"inventoryList":{"$ref":"#/definitions/RESULTSET"},"message":"status":}}}},"parameters":[{"name":"batchNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"expirationDate","in":"query","type":"string","description":"Implicit parameter"},{"name":"expirationDateTo","in":"query","type":"string","description":"Implicit parameter"},{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"groupByEntity","in":"query","type":"string","description":"Implicit parameter"},{"name":"includeZero","in":"query","type":"string","description":"Implicit parameter"},{"name":"inventoryType","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemClassification","in":"query","type":"string","description":"Implicit parameter"},{"name":"itemCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"limit","in":"query","type":"string","description":"Implicit parameter"},{"name":"locationName","in":"query","type":"string","description":"Implicit parameter"},{"name":"locationType","in":"query","type":"string","description":"Implicit parameter"},{"name":"lotNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"lotStatus","in":"query","type":"string","description":"Implicit parameter"},{"name":"makeDate","in":"query","type":"string","description":"Implicit parameter"},{"name":"makeDateTo","in":"query","type":"string","description":"Implicit parameter"},{"name":"offset","in":"query","type":"string","description":"Implicit parameter"},{"name":"orderBy","in":"query","type":"string","description":"Implicit parameter"},{"name":"otherOrganization","in":"query","type":"string","description":"Implicit parameter"},{"name":"owner","in":"query","type":"string","description":"Implicit parameter"},{"name":"palletCode","in":"query","type":"string","description":"Implicit parameter"},{"name":"prepriceYesNo","in":"query","type":"string","description":"Implicit parameter"},{"name":"produceTimeFrom","in":"query","type":"string","description":"Implicit parameter"},{"name":"produceTimeTo","in":"query","type":"string","description":"Implicit parameter"},{"name":"sortBy","in":"query","type":"string","description":"Implicit parameter"},{"name":"sscc","in":"query","type":"string","description":"Implicit parameter"},{"name":"unitId","in":"query","type":"string","description":"Implicit parameter"},{"name":"unitIdList","in":"query","type":"string","description":"Implicit parameter"},{"name":"unitOfMeasure","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"},{"name":"vendorLotNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"unitCode","in":"header","type":"string","required":true}]}},"/movepalletlist":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"locationName","in":"header","type":"string","required":true},{"name":"palletList","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/palletTrackingList":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"message":"palletTrackingList":{"$ref":"#/definitions/RESULTSET"},"status":}}}},"parameters":[{"name":"accountNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"appointmentId","in":"query","type":"string","description":"Implicit parameter"},{"name":"dateFrom","in":"query","type":"string","description":"Implicit parameter"},{"name":"dateTo","in":"query","type":"string","description":"Implicit parameter"},{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"grouping","in":"query","type":"string","description":"Implicit parameter"},{"name":"limit","in":"query","type":"string","description":"Implicit parameter"},{"name":"loadId","in":"query","type":"string","description":"Implicit parameter"},{"name":"offset","in":"query","type":"string","description":"Implicit parameter"},{"name":"orderNumber","in":"query","type":"string","description":"Implicit parameter"},{"name":"organization","in":"query","type":"string","description":"Implicit parameter"},{"name":"palletType","in":"query","type":"string","description":"Implicit parameter"},{"name":"transactionType","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/pallettypelist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"palletTypeList":{"$ref":"#/definitions/RESULTSET"},"returnMessage":"returnStatus":}}}},"parameters":[{"name":"export","in":"query","type":"string","description":"Implicit parameter"},{"name":"limit","in":"query","type":"string","description":"Implicit parameter"},{"name":"offset","in":"query","type":"string","description":"Implicit parameter"},{"name":"organization","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"},{"name":"weightUom","in":"query","type":"string","description":"Implicit parameter"}]}},"/partialpallets":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"org","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"query","type":"string","description":"Implicit parameter"}]}},"/productionloginfo":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"batchType","in":"header","type":"string","required":true},{"name":"dateFrom","in":"header","type":"string","required":true},{"name":"dateTo","in":"header","type":"string","required":true},{"name":"export","in":"header","type":"string","required":true},{"name":"groupByEntity","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/reclasspallets":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"itemCode","in":"header","type":"string","required":true},{"name":"palletIds","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true},{"name":"validateOnlyFlag","in":"header","type":"string","required":true}]}},"/requestmove":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"cartId","in":"header","type":"string","required":true},{"name":"forceMove","in":"header","type":"string","required":true},{"name":"thirdPartyLocationId","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/rmpulllist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"batchStatuses","in":"header","type":"string","required":true},{"name":"export","in":"header","type":"string","required":true},{"name":"fromPlannedStart","in":"header","type":"string","required":true},{"name":"itemTypes","in":"header","type":"string","required":true},{"name":"locationTypes","in":"header","type":"string","required":true},{"name":"productionLines","in":"header","type":"string","required":true},{"name":"toPlannedStart","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/splitunit":{"post":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{"message":"status":}}}},"parameters":[{"name":"payload","in":"body","required":true,"schema":{"$ref":"#/definitions/PAYLOAD4"}}]}},"/stockcodeshipmentslist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"expirationDate","in":"header","type":"string","required":true},{"name":"export","in":"header","type":"string","required":true},{"name":"itemCode","in":"header","type":"string","required":true},{"name":"orderNumber","in":"header","type":"string","required":true},{"name":"transactionDateFrom","in":"header","type":"string","required":true},{"name":"transactionDateTo","in":"header","type":"string","required":true},{"name":"userSessionId","in":"header","type":"string","required":true}]}},"/unitstatuslist":{"get":{"description":null,"responses":{"200":{"description":"output of the endpoint","schema":{"type":"object","properties":{}}}},"parameters":[{"name":"poReceivable","in":"query","type":"string","description":"Implicit parameter"},{"name":"userSessionId","in":"header","type":"string","required":true}]}}},"definitions":{"RESULTSET":{"type":"string"},"PAYLOAD1":{"properties":{"userSessionId":{"type":"string"},"unitId":{"type":"string"},"printerName":{"type":"string"},"copies":{"type":"string"},"locationName":{"type":"string"}}},"PAYLOAD2":{"properties":{"userSessionId":{"type":"string"},"organization":{"type":"string"},"palletType":{"type":"string"},"quantity":{"type":"string"},"orderHeaderId":{"type":"string"},"receiptId":{"type":"string"},"transactionDate":{"type":"string"}}},"PAYLOAD3":{"properties":{"itemCode":{"type":"string"},"quantity":{"type":"string"},"uom":{"type":"string"},"numberOfUnits":{"type":"string"},"organization":{"type":"string"}}},"PAYLOAD4":{"properties":{"userSessionId":{"type":"string"},"unitId":{"type":"string"},"quantity1":{"type":"string"},"uom1":{"type":"string"},"quantity2":{"type":"string"},"uom2":{"type":"string"},"locationName":{"type":"string"},"printerName":{"type":"string"},"copies":{"type":"string"}}}}}

Comments
Post Details
Added on Aug 15 2019
4 comments
832 views