Home > Forum > Rules, JS, SQL > Parsing nested JSON REST API with OpenJSON SQL query

Parsing nested JSON REST API with OpenJSON SQL query

0

Tom Obermayr

05.06.2023

09:29

Tom Obermayr

I'm having some troubles using OPENJSON to parse a nested JSON response from a REST API:

Following the solution posted at https://alterpaths.com/json-nested-collection-handling-in-webcon-bps/ but I cannot get the query to work in Webcon.

When copying the whole query from the Show window into SQL Studio it works just as expected, but in WebCon Designer studio the following error occurs (see screenshot).

Any ideas how to proceeed here?

Tomasz Smuga

10.04.2025

11:16

Tomasz Smuga

Hello

I'm having the same problem. Have you got solution for this problem.

Solution (0)

Helpful (0)

Wrong answer (0)