May be this?
Load * where moment = 'monthname';
RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"id" AS "id_u0",
"accountId",
"shared",
"version",
"updated",
"name" AS "name_u1",
"externalCode",
"moment",
"applicable",
"sum",
"created",
"vatEnabled",
"vatIncluded",
"vatSum",
"payedSum",
"__KEY_rows",
"__FK_rows"
FROM "rows" PK "__KEY_rows" FK "__FK_rows")
FROM JSON (wrap on) "root" PK "__KEY_root"
;
Make sure, the month name should be calculated like
Month(moment) as Month_moment
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
