Forum Discussion

HEATConsultant's avatar
HEATConsultant
Occasional Contributor
7 years ago

Data Import from SQL Database

SOAP Newbie here.

 

Successfully created my first SOAP Project and request to create a record.

 

Now how can I do a mass import by getting the data from a SQL Database source file and then loop through my soap request?

 

Thanks in advance!

  • selva29's avatar
    selva29
    Occasional Contributor

    Hi , 

     

    I cant able to execute complex POSTGRES query form JDBC Request and get the response . same query is working fine in the POSTGRES console and get the result .

     

    Is Soap ui accepts only the sql query , post-gres query are not working from jdbc request?, if so what will the solution for this? Please someone clarify 

     

    query which i tried: 


    select Max(NULLIF(regexp_replace(reference_id, '[^0-9.]*','','g'), '')::numeric)
    from transactions as ref_id 

     

    Thanks