Create Order API
Our Company recently started working w/ a new lab for our patient's lab work / tests and they require API integration for the creation of the orders for the which ever lab the patient is requesting or needs.
I have NEVER worked w/ API anything and i'm very new to working with quickbase on this end of things. Forms, fields, relationships i've got all down, But API's i've been afraid to touch. If someone can point me in the right direction as to where to even begin i'm pretty sure i can figuure out the rest. I've included the documentation provided to me by the lab as well as pasted the info below.
All of the information that is referenced below is in each patients record as a field for each piece of information. if anyone could please help?? where does this information get plugged into quickbase?
POST
{
//The order number in your system
"Requisition": "O121018003",
"BillTo": "Primary Insurance",
"Location": {
"LocationCode": "",
"LocationName": ""
},
"Physician": {
"NPI": "1518466556",
"FirstName": "KATHERINE",
"LastName": "KLICK"
},
"CollectionDate": null,
//See Notes Below
"TestCategory": "PGX",
"ICD10List": [
{
"Code": "A15.0",
"Name": ""
}
],
//List of NDC11 codes
Confidential
"Medications": [
{
"Code": "57691-0114-30",
"Name": "01 Balancing Foundation"
}
],
//Test panel code must match the list in IAL system - See Notes Below
"Tests": [
{
"Code": "Pain",
"Name": ""
}
],
"Patient": {
//The patient number in your system
"Code": "",
"FirstName": "API",
"MiddleName": "",
"LastName": "Patient",
"DOB": "1/1/1985",
"Address": {
"Address1": "333 Swanson rd",
"Address2": "St 107",
"City": "Lowerensvill",
"State": "GA",
"ZipCode": "30043",
"Phone": "000-000-0000",
"Fax": "",
"Email": "aladin@iatserv.com",
"CountryCode": "USA"
},
"Gender": "Male",
"Race": "Asian"
},
"PrimaryInsurance": {
"InsuranceCode": "HM",
"InsuranceName": "HUMANA",
"Policy": "PA4521",
"GroupNo": "GR005",
"InsuredRelationship": "Self",
"InsuredInfo": {
"Code": null,
"FirstName": "Mary",
"MiddleName": null,
"LastName": "Doe",
"DOB": "5/5/1997",
"Address": {
"Address1": "333 Swanson rd",
"Address2": "Suite 107",
"City": "Lowerensvill",
"State": "GA",
"ZipCode": "30043",
"Phone": "777-777-7777",
Confidential
"Fax": null,
"Email": null,
"CountryCode": "USA"
},
"Gender": "Female",
"Race": null
}
}, "Files" : [ { "Name" : "String", "Base64Data" : "String", "Note" : "String", "ContentType" : { "type" :"string", "information":{ "values":[ "Auto", "PDF", "JPEG", "GIF", "PNG", "TIFF", "Text" ] } } } ]
}
Confidential
Response Status Response
200
{
//If true that means the order is created
"Success": "Boolean",
//The status of the response if 201 the order is created
//If 409 or 500 please check the errors below
"StatusCode": Int32,
"Errors": [
{
"Code": "String",
"Description": "String"
}
]
}
401
{"message": "Attempted to perform an unauthorized operation"}
403
{"message": "You don't have access to this resource"}
500
{"message": "Detailed message about the error."}
------------------------------
Josue Ruiz
------------------------------
I have NEVER worked w/ API anything and i'm very new to working with quickbase on this end of things. Forms, fields, relationships i've got all down, But API's i've been afraid to touch. If someone can point me in the right direction as to where to even begin i'm pretty sure i can figuure out the rest. I've included the documentation provided to me by the lab as well as pasted the info below.
All of the information that is referenced below is in each patients record as a field for each piece of information. if anyone could please help?? where does this information get plugged into quickbase?
POST
{
//The order number in your system
"Requisition": "O121018003",
"BillTo": "Primary Insurance",
"Location": {
"LocationCode": "",
"LocationName": ""
},
"Physician": {
"NPI": "1518466556",
"FirstName": "KATHERINE",
"LastName": "KLICK"
},
"CollectionDate": null,
//See Notes Below
"TestCategory": "PGX",
"ICD10List": [
{
"Code": "A15.0",
"Name": ""
}
],
//List of NDC11 codes
Confidential
"Medications": [
{
"Code": "57691-0114-30",
"Name": "01 Balancing Foundation"
}
],
//Test panel code must match the list in IAL system - See Notes Below
"Tests": [
{
"Code": "Pain",
"Name": ""
}
],
"Patient": {
//The patient number in your system
"Code": "",
"FirstName": "API",
"MiddleName": "",
"LastName": "Patient",
"DOB": "1/1/1985",
"Address": {
"Address1": "333 Swanson rd",
"Address2": "St 107",
"City": "Lowerensvill",
"State": "GA",
"ZipCode": "30043",
"Phone": "000-000-0000",
"Fax": "",
"Email": "aladin@iatserv.com",
"CountryCode": "USA"
},
"Gender": "Male",
"Race": "Asian"
},
"PrimaryInsurance": {
"InsuranceCode": "HM",
"InsuranceName": "HUMANA",
"Policy": "PA4521",
"GroupNo": "GR005",
"InsuredRelationship": "Self",
"InsuredInfo": {
"Code": null,
"FirstName": "Mary",
"MiddleName": null,
"LastName": "Doe",
"DOB": "5/5/1997",
"Address": {
"Address1": "333 Swanson rd",
"Address2": "Suite 107",
"City": "Lowerensvill",
"State": "GA",
"ZipCode": "30043",
"Phone": "777-777-7777",
Confidential
"Fax": null,
"Email": null,
"CountryCode": "USA"
},
"Gender": "Female",
"Race": null
}
}, "Files" : [ { "Name" : "String", "Base64Data" : "String", "Note" : "String", "ContentType" : { "type" :"string", "information":{ "values":[ "Auto", "PDF", "JPEG", "GIF", "PNG", "TIFF", "Text" ] } } } ]
}
Confidential
Response Status Response
200
{
//If true that means the order is created
"Success": "Boolean",
//The status of the response if 201 the order is created
//If 409 or 500 please check the errors below
"StatusCode": Int32,
"Errors": [
{
"Code": "String",
"Description": "String"
}
]
}
401
{"message": "Attempted to perform an unauthorized operation"}
403
{"message": "You don't have access to this resource"}
500
{"message": "Detailed message about the error."}
------------------------------
Josue Ruiz
------------------------------
