How to get items list on Sales Invoice through REST API?

ERPNext
1

Hi. I want to retrieve items list from several sales invoice through this REST API:

curl_init(‘http://icareindo.id/api/resource/Sales%20Invoice?fields=[“name”,“items”]’);

But I got OperationalError: (1054, “Unknown column ‘items’ in ‘field list’”) even though column items is actually in data

hl
hl300×571 24.1 KB

I suspect that it is because column items is an array.
How do I get the items list through REST API? Thank you

2

To get item details you need to call particular invoice.

eg:

http://testrazorpay.erpnext.dev:8000/api/resource/Sales%20Invoice/SINV-00001
3

Right, the image I showed is from retrieving the data of 1 sales invoice. but how to get more than 1 sales invoice? And for certain field list only? (e.g. name, items, and due_date)

4

You need two requests for this

  1. To get list all Sales Invoices,
http://testrazorpay.erpnext.dev:8000/api/resource/Sales%20Invoice
  1. From above list, pull details for individual Sales Invoice
http://testrazorpay.erpnext.dev:8000/api/resource/Sales%20Invoice/SINV-00001
5

I see… So there is no other alternative then. Thanks Saurabh6790