Trigger http request to make a post request in loops

DECLARE
  response TEXT;  -- Use TEXT instead of JSONB
  payload JSON;   -- Variable to hold the JSON payload
BEGIN
  RAISE NOTICE 'Payload to Loops API:';

  -- Construct the JSON payload
  payload := json_build_object(
    'email', NEW.email
  );

  -- Log the payload being sent
  RAISE NOTICE 'Payload to Loops API: %', payload;

  BEGIN
    -- Send HTTP request
    SELECT content INTO response
    FROM http(('POST', 'https://app.loops.so/api/v1/contacts/create', ARRAY[http_header('Authorization', 'Bearer <api key>')], 'application/json',payload::text)::extensions.http_request);

    -- Log the response received
    RAISE NOTICE 'Response from Loops.so: %', response;

  EXCEPTION 
    WHEN OTHERS THEN
      RAISE NOTICE 'Failed to send data to Loops.so: %', SQLERRM;
  END;

  RETURN response;
END;