authen.public

Parameters

Name	Type	Mode
prop_code	text	IN
report_id	integer	IN
params	json	IN
file_path	text	IN
file_name	text	IN (DEFAULT NULL)
export_format	text	IN (DEFAULT 'pdf')
expire_secs	bigint	IN (DEFAULT (((7 * 24) * 60) * 60))

Definition

DECLARE 
    _content_type TEXT;
    _file_content bytea; 
    _file_path TEXT;
    _status int;
    _content text;
    gen_params jsonb;
    service_url text = 'https://dev.fromas.cloud/v2/pms/report/generate';
    --response http_response;
    result_json jsonb;
    ACCESS_TOKEN TEXT 
    = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjUxOTkiLCJ1aWQiOjEzNSwicGlkIjo0LCJwZ2lkIjoxLCJwY29kZSI6ImFvbmVzdGFyIiwibmFtZSI6InN5c3Rlc3RlciIsInVndCI6IlAiLCJpYXQiOjE1NzkyNDUyMTR9.3Um4gB7CqcO9qsDe5facWXaivvWGqgXoRUz0xU0ru00';
begin
    gen_params := json_build_object(
          'report_id', report_id,
          'export_type', 'url',  
          'export_format', export_format,  
          'url_expire', expire_secs, -- 7 days (maximum)  
          'params', params 
    ); 

    Select resp.status, resp.content 
    from http(('POST', 
               service_url, 
               ARRAY[http_header('Authorization','Bearer '||fn_get_config(0, 'REPORT_GEN_TOKEN', ACCESS_TOKEN))], 
               'application/json', 
               gen_params::text)) as resp
    INTO _status, _content;

    PERFORM sp_raise_error_if(_status <> 200, 'Create report failed, '||_content);    

    raise notice '[%] %', _status, _content;

    if _status = 200 then
        result_json := _content::jsonb;
        if result_json->>'status' <> '200' then
            raise exception '%', result_json->>'message';
        else
            return result_json->>'data'; 
        end if;
       -- PERFORM sp_raise_error_if(result_json->>'status' <> '200', 'Create report failed, '||result_json->>'message');         
    else
        raise exception '%', _content;
    end if;
END

sp_gen_report_url2

Parameters

Definition