How to get specific record / Filter using Odata Endpoint

(0) Share

Report

Posted on by AX 2012 r3

2,426

Good morning,

i am trying to update Purchase order line from console application.

i found this piece of code for update

this foreach loop will loop for all the records.

In my case if i have 5000 Purchase orders it is going to check in foreach loop 4999 times.

So to avoid this i want to filter only that particular PO and that particular line record.

in my case i need to update specific line for Purchase order.

Suppose i want to update Purchase order line - Line number 2.

How can i filter records from context.PurchPurchaselineentity

Please show some light on this.

Regards,

Have a nice day.

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can use LINQ query to fetch the line. Take a look at below article to see how it is used.

stoneridgesoftware.com/.../

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

You can check the example here for filtering specific records.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi all,

I found this URL

"axguru.com/.../"

This pic is from URL how this is possible

how can i achieve same thing

But when i used same thing i am getting error.

Please suggest me how can i use linq Query should i have to install any assembly for that?

Regards,

Have a nice day

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi,

I have referred to using System.Linq;

Its working now.

Let me test more and come back.

Regards

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi AX 2012_r3,

You need to import the namespace System.Linq at the beginning of the file.

using System.Linq

docs.microsoft.com/.../working-with-linq

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi ,

When i am updating i am getting this error

InnerException = "{\r\n \"error\":{\r\n \"code\":\"\",\"message\":\"An error has occurred.\",\"innererror\":{\r\n \"message\":\"Write validation failed for table row of type 'SalesOrderLineV2Entity'. Infolog: .\",\"type\":\"Microsoft.Dynamics.Platform.Integration.S...

can we debug this not sure what is happening i am trying to update only one field line description

It is throwing this error

Please show some light on this how can i skip this.

Regards,

Have a nice day.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

This means that data validation is failing for the row. Can you debug the code and check where the validation is failing?

Also, you can try updating record (with the same values) using the entity with a runnable class.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Please share your code where you are doing update. Also whats the actual validation error ? can you share that ?

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi all,

Resolved with the above code.

Please review it and let me know if that is correct or not

Now Quantity got updated to 9.

Please review the code and let me know is that clean code or should i change ?

Please let me know experts.

Regards,

Have a nice day.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

As long as you are able to select correct lines , you should be good. We don't know your business scenario , the information which you shared is you want to select and update line which seems to be working correct according to code you shared. If there is nothing left please close the thread.

Was this reply helpful? Yes No