Business Central Find purchase lines

(0) Share

Report

Posted on by M Peeters

Hi all,

I am trying to find purchase order lines in Business Central with the standard API and the find record action.

First i find my Purchase order and then i find my purchase order lines with the next filter Document-ID eq 'ID' where ID come from the previous find purchase order action.

It keeps telling me that there is an error on position 9 meaning the "-"symbol.

I dont thing there is an errr anywhere, is this a bug in the find Records of the Business Central connector?

"Syntax error at position 9 in 'Document-id eq '938dfe78-90ed-ec11-82f8-000d3a2062d7''."

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MarkPeeters，

It seems like that you have referred to a wrong field name.

Could you please remove the expression within the FilterQuery and run the flow, check the output from this action and find out the real field name of this Document-ID?

Was this reply helpful? Yes No
M Peeters 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Qi,

This is what i normally do. And that works for every table except Purchaseorderlines eand saleorderlines.
If i execute a find records on the purchaselines without a query i get this error.
ErrorCode: Application_DialogException You must specify an Id or a Document Id to get the lines. CorrelationId: e9965115-d679-404f-b321-87ac7f5f4012.
clientRequestId: fc2b4577-2fce-4ee8-bf8b-ae1ae1d60f4b

It looks like a bug in the api to me.

Please advice

Was this reply helpful? Yes No
preeteebeefeya 4 on at

Like (0)

Report
Copy link

Link copied!

I confirm that it is still not working

Was this reply helpful? Yes No
dejadpower 40 on at

Like (1)

Report
Copy link

Link copied!

hi

you just have to use the filter query as documentId eq SELECT ID COLUMN

note after eq , there is no quotes surrounding the Id column

Was this reply helpful? Yes No
PejuangPower 5 on at

Like (0)

Report
Copy link

Link copied!

Great,, The quote is the problem, Thanks

Was this reply helpful? Yes No