usage of FOR JSON PATH in subquery give "Unsupported operator for resource actuals feedback"

[pankaj_j]

I Iam trying to generate Source to Target mapping in JSON, to use it in pipeline, from source column and target column comma separated list. These lists are stored in respective columns in a row for the source table. Below you can find the query. It throws  "Unsupported operator for resource actuals feedback". Is it true that "FOR JSON PATH" not supported yet in subquery?

Please find the query below:

select repl_key,REPLACE('{"type": "TabularTranslator", "mappings": {m}}','{m}', (
             SELECT TRIM(srccol.value) AS [source.name]
                   ,TRIM(snkcol.value) AS [sink.name] 
               FROM STRING_SPLIT(CONCAT(TRIM(REPLACE(l.key_columns
                   ,SPACE(1), SPACE(0))), ',tracking_timestamp, inactive_ind'), ',') srccol 
              CROSS APPLY STRING_SPLIT(CONCAT(TRIM(REPLACE(l.key_columns
                         ,SPACE(1), SPACE(0))), ',tracking_timestamp, inactive_ind'), ',') snkcol 
              WHERE srccol.value = snkcol.value for json path ))                 AS logiDelMapping
FROM utility.repl_list l

[Anonymous]

Hi @pankaj_j,

I'd like to suggest you take a look the following document which mention about the limitations of t-sql query in data warehouse of hope:

T-SQL surface area - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

[pankaj_j · Accepted solution]

I did look at it. It seems FOR JSON PATH is supported but not it subquery. Thanks anyways. I had to use script in foreach loop to achieve the functionality.