My Custom API Code
module.exports = function(service) {
service.get('/mobile/custom/DBRequisition/DBRequisitionList', function(req,res) {
req.oracleMobile.database.getAll(
'Requisition', {fields: 'REQUISITION_NUMBER,REQUISITION_STATUS'}).then(
function (result) {
res.type('application/json');
res.send(result.statusCode, result.result);
},
function (error) {
res.send(error.statusCode, error.error);
}
);
});
};
===========
it works fine on mcs custom api test console giving following output:
{
"items":
[
{
"Requisition_Number": "10001",
"Requisition_Status": "Submitted",
"Requisition_Amount": "200",
"Requisition_Description": "Req Description",
"Requisition_Justification": "Req Justification",
"Requester_Name": "David",
"Item_Purchased": "Printer",
"Requested_Delivery_Date": "10-jan-2018"
},
{
"Requisition_Number": "10002",
"Requisition_Status": "Rejected",
"Requisition_Amount": "300",
"Requisition_Description": "Req Description",
"Requisition_Justification": "Req Justification",
"Requester_Name": "David Jose",
"Item_Purchased": "Printer 123",
"Requested_Delivery_Date": "10-jan-2018"
},
{
"Requisition_Number": "10003",
"Requisition_Status": "In Progress",
"Requisition_Amount": "300",
"Requisition_Description": "Req Description",
"Requisition_Justification": "Req Justification",
"Requester_Name": "David Jose",
"Item_Purchased": "Printer 123",
"Requested_Delivery_Date": "10-jan-2018"
},
{
"Requisition_Number": "10004",
"Requisition_Status": "Completed",
"Requisition_Amount": "300",
"Requisition_Description": "Req Description",
"Requisition_Justification": "Req Justification",
"Requester_Name": "David Jose",
"Item_Purchased": "Printer 123",
"Requested_Delivery_Date": "10-jan-2018"
}
]
}
===========
But when Adding data using MAX it displays my published API but the object doesn't appear.It says "Unable to bind Business Object.The selected business object does not return a list of items".Could you please help IS there anything i am doing wrong?
Santosh