Answered

Find records (V3) filter for exact match

Like (0) Share

Report

Posted on 30 Dec 2021 11:39:36 by Damjan Zakojc

Hi All,

I am using a cloud flow where I would like to search for a record in the table Employee based on the string found in the 3rd party applicaiton the previous step of the flow.

This is my flow:

1. user initiates the flow and inserts the number value

2. based on the inserted number value a record in the 3rd party application is received as expected

3. here I would like to get the record in table Employee of Business Central database (SaaS)

- I extended the table "Employee" with custom fields; and page "Employee Card" and "Employee List" and API page "Employee Card" where I display those custom fields (this works as expected)

- I would like to check if employee with the number user has inserted on step 1 already exists in the table "Employee", just my filtering is not working here (marked with red square). It always returns all the records found in the table "Employee", where I would like to get exact match.

Thank you

BR Damjan

I have the same question (0)

All responses (5)

Answers (1)

Damjan Zakojc 18 on 03 Jan 2022 at 13:09:05

Like (0)

Report

Re: Find records (V3) filter for exact match

Hi,

just sorted my issue.
It works as expected. Only 1 records is received as expected. I had to do it like this

the XML output gets 1 record as expected

tnx Damjan

Was this reply helpful? Yes No
Damjan Zakojc 18 on 03 Jan 2022 at 12:59:35

Like (0)

Report

Re: Find records (V3) filter for exact match

Hi

column name is actually "No.", while caption is set to "number". It works with both versions ('No.';'number'), but it always gets all the records, although I set the filter to 'No.' eq 'Number' (this is the user inserted string value as flow is triggered).

This gets all the records in the XML output file, while I need to get only 1 record where filter is set to 'No.' = 1007 -> 1007 is inserted as user input as flow is triggered.

xml output

tnx Damjan

Was this reply helpful? Yes No
Verified answer

DeepakS 2,301 Most Valuable Professional on 31 Dec 2021 at 21:19:18

Like (0)

Report

Re: Find records (V3) filter for exact match

In filter query you should use the actual name of the column I am not sure in DB the column name is "No." or "Number"

here is a reference :

If column name is "No"

No eq '1007'

If column name is "Number"

Number eq '1007'

Was this reply helpful? Yes No
Damjan Zakojc 18 on 31 Dec 2021 at 07:28:16

Like (0)

Report

Re: Find records (V3) filter for exact match

Hi,
I tried with your suggestion, but it doesn't find the record that already exist in the table Employee in Business Central database.
- filter query: number is actually field: "No." on table "Employee", where 'Number value' is user inserted value as the flow is initiated.

this is the call:

this is the output xml from upper call
- body is blank, although record with value 1007 on field: "No." does exist in table "Employee" in BC database.

if I try to filter for an value on field: number that I know that does not exist in the BC database, I get same output content, where again body is blank.

thanks

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on 30 Dec 2021 at 16:57:37

Like (1)

Report

Re: Find records (V3) filter for exact match

Hi ,

Looking at you screen capture ,I think filter query expression is not correct you should use following instead:

number eq 'number value' ( no single quote mark on column name )

Regards.

Was this reply helpful? Yes No