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

Parsing nested JSON REST API with OpenJSON SQL query
0

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?

Nobody has replied in this thread yet.