PostGres SQL data update No value column to Update

[christinaliu]

I have some data to insert into a postgres sql database table. The insert script below works in PGadmin but not able to insert through alteryx. The datatype matches to the datatype of the database table.  

CALL eqto.trade_surface_run_underlier_exclusion_write(

  _run_id := 1,

  _exclusions_json := '[

    { "ric": "AAPL.OQ", "expiry_date": "2024-05-01", "strike": 100 },

    { "ric": "AAPL.OQ", "expiry_date": "2024-05-01", "strike": 101 }

  ]'::JSONB

);

Error is: 

Output Data (3) No value column to Update

Any idea how to solve this? 

[Shoaib345 · Accepted solution]

DO $$

BEGIN

  CALL eqto.trade_surface_run_underlier_exclusion_write(

    _run_id := 1,

    _exclusions_json := '[{"ric": "AAPL.OQ", "expiry_date": "2024-05-01", "strike": 100}, {"ric": "AAPL.OQ", "expiry_date": "2024-05-01", "strike": 101}]'::JSONB

  );

END;

$$;

[apathetichell]

is this in input data/presql--- see https://analytics-x.tech/en/archives/5660