Click here to Skip to main content
15,867,865 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have to read invoice line items.
To Read all invoices
• projection/v1/InvoiceHandling.svc
This would list all the invoices in all company registered in cloud(Only Header Info)
To Read exact invoice
• projection/v1/InvoiceHandling.svc/SuppInvoiceSet?$filter=Company eq '10' and InvoiceId eq 202646
This would list InvoiceId-202646(Only Header Info)

To Read Item Lines
•projection/v1/InvoiceHandling.svc/SuppInvoiceSet(Company='{Company}',InvoiceId={InvoiceId})/SuppInvoiceItems
This would list item lines (Need to pass Company Id and InvoiceId)

What I need to do is filter Item line based on some condition.Eg: List all Item Lines that Line Part Description "Delivery" .

What I have tried:

I have tried expand option before applying filter in child. But it didn't work.
projection/v1/InvoiceHandling.svc/SuppInvoiceSet?$expand=SuppInvoiceItems
Posted
Updated 21-Dec-22 19:55pm
v2

1 solution

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900