Answered

Can`t use SQL Get Rows V2

(0) Share

Report

Posted on by ITS-David

Hey!
I'm having problems with SQL Get Row's V2.
When I set it up, everything works as it should. It finds the server, database and the table but no matter what filter query I set I get the same error. Even without any querys. (See pictures)

Then I get following error:

It works perfect with Get Rows V1 in old configs!

I realy need to get this to work... Does anyone have any ideas ?!?

Thank you
//David

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Daviid,

Do you still have the same problem?

I'm afraid it was an accidental mistake, which has now been corrected.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ITS-David 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Now it works perfect!!
Thank you so much!

//David

Was this reply helpful? Yes No
ITS-David 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi agian @v-litu-msft

I got the same problem again when put a new Get Row V2!

InvalidTemplate.Unable to process template language expressions in action 'dbo.Blikk' inputs at line '1' and column '2655': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sql_1']['connectionId']' cannot be evaluated because property 'shared_sql_1' doesn't exist, available properties are 'shared_sql'. Please see https://aka.ms/logicexpressions for usage details.'.

Is it the same problem?!

//David

Was this reply helpful? Yes No