Data seen in mariaDB but can not access in endPoint API

[Rajesh_Sukheja]

Hello,

I’m beginner in ERPNext
I got empty curtly braces {} while using API endpoint

http://localhost:8000/api/method/abc.api.get_item_details

created custom app called ‘abc’ and created function ‘get_item_details’ in ’ api.py’ file

complete code in the ‘api.py’ file :
import frappe
@frappe.whitelist(allow_guest=True)
def get_item_details(item=None):
Item = frappe.db.sql(‘’‘select * from tabItem docType;’‘’, as_dict=True )
return item

file location : apps/abc/abc/api.py

is there anything which i missed and can not see the output THOUGH I CAN SEE THE DATA IN MARIADB

[TurkerTunali]

@Rajesh_Sukheja

select * from tabItem docType

Does this query return anything in you sql editor?

[Rajesh_Sukheja]

@Rajesh_Sukheja

select * from tabItem docType

yes yes… complete details

[TurkerTunali]

Can you share a screenshot?

[Rajesh_Sukheja]

i can see the result in mariaDB

[Antony_Praveenkumar]

@Rajesh_Sukheja

Item = frappe.db.sql(‘’‘select * from tabItem docType;’‘’, as_dict=True )

change that line to this

Item = frappe.db.sql(‘’‘select * from tabItem’‘’, as_dict=True )

[Rajesh_Sukheja]

tried, but same result

[Antony_Praveenkumar]

Frappe Rest API | Custom Rest API

REST API Documentation Step 1: Create a Custom doctype in your Custom app assume Whatsapp your custom app and Status is your custom doctype Step 2: Task Create a 2 API create_satatus and delete_status Step 3: Create API in Status Doctype status.py import json import frappe from frappe.model.document import Document from werkzeug.wrappers import Response from frappe.utils import response as r class ShoppingCart(Document): pass @frappe.whitelist(method='POST') def create_status(…

Use this response type and return it

from werkzeug.wrappers import Response
from frappe.utils import response as r

Don’t return simply a dict

If the above documentation is not working try this:

import frappe
from frappe.utils import response

@frappe.whitelist(allow_guest=True)
def get_item_details(item=None):
  Item = frappe.db.sql("select * from tabItem", as_dict=True )
  response['http_status_code'] = 200
  response['data'] = Item
  return

Note: If its not working add method type and hit with respective method like this

@frappe.whitelist(allow_guest=True, method='POST')

[Rajesh_Sukheja]

Thanks for your valuable time @TurkerTunali , @Antony_Praveenkumar , i appreciate your efforts.
it’s finally resolved and now i can get the data by creating a file called abc.py in my app’s config folder and wrote this code

def get_data():
return [{
“label”: _(“Masters”),
“items”: [
{
{
“type”: “doctype”,
“name”: “Item”,
},
}
]
}]

this is for the ref : Custom app calling doctypes from different modules - #2 by Ben_Cornwell_Mott

but once again thanks a lot