Http request failed: the content was not a valid JSON with SQL Get rows (V2) connector

(0) Share

Report

Posted on by dc7669

152

Hi,

I retrieved a list of items from SP List. I want to go through each item of the list to check against another table stored in an on-premise SQL table. I used the "Get rows (V2)" connector. This connector works outside of the "Apply to each". When it is within "Apply to each", the run log showed that both Server name and Database name are "default", instead of my Server name/Database name as I set up in the Power Automate.

How should this be corrected?

dchan

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Hi @dchan1 ,

Could you share screenshots of the two configurations? Is the configuration of these two configurations different in Server name/Database name?

Please provide more details so that we could analyze this issue.

Best Regards,

Was this reply helpful? Yes No
Verified answer

dc7669 152 on at

Like (0)

Report

Hi,
I found the answer!
It was in the Filter Query section. The below screen shot can be run successfully within the "Apply to Each".
The "Status" and "EmployeeID" are field names in the data table in SQL database. I did not have correct case format and thus, it threw me the error. I thought the field names were case insensitive.

Thanks!
dchan1

Was this reply helpful? Yes No