Deleting vendor invoice journal line using OData

(0) Share

Report

Posted on by tl2022

103

Hi, I am running into problem deleting journal lines. When I do the GET query below, it returns me the row of data that I'm expecting, but when I try to delete using the DELETE query below, I get an error that says "No resources were found when selecting for update". What am I doing wrong?

GET:
https://{{HOST}}/data/VendInvoiceJournalLines?cross-company=true&$filter=dataAreaId eq '442' and JournalBatchNumber eq '002823' and LineNumber eq 1

DELETE:
https://{{HOST}}/data/VendInvoiceJournalLines(dataAreaId='442',JournalBatchNumber='002823',LineNumber=1)

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Can you try adding cross-company keyword in DELETE query as well. Probably, your user's default company is not 442.

By default, OData returns only data that belongs to the user's default company. To see data from outside the user's default company, specify the ?cross-company=true query option. This option will return data from all companies that the user has access to.

You can try your Delete query directly on browser and it will fail with this error 'No webpage was found for the web address'.

Please use same as Get query and issue should be fixed.

Was this reply helpful? Yes No
tl2022 103 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohit, so I tried that but the request is not working. I don't know what I am doing wrong:

DELETE:

https://{{HOST}}/data/VendInvoiceJournalLines(cross-company=true,dataAreaId='442',JournalBatchNumber='002823',LineNumber=1)

Error:

{

"Message": "No HTTP resource was found that matches the request URI 'https://{{HOST}}/data/VendInvoiceJournalLines(cross-company=true,dataAreaId='442',JournalBatchNumber='002823',LineNumber=1)'. No route data was found for this request."

}

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

I tried your query and it doesn't work from browser.

But the query you have for Get works well. You can try both queries directly in browser to fetch data and see the difference.

Please use the below query to delete the record

https://{{HOST}}/data/VendInvoiceJournalLines?cross-company=true&$filter=dataAreaId eq '442' and JournalBatchNumber eq '002823' and LineNumber eq 1

Was this reply helpful? Yes No
Verified answer

tl2022 103 on at

Like (1)

Report
Copy link

Link copied!

I figured it out! I just needed to put cross-company after everything, outside of the parenthesis:

https://{{HOST}}/data/VendInvoiceJournalLines(dataAreaId='442',JournalBatchNumber='002823',LineNumber=1)?cross-company=true

Was this reply helpful? Yes No