Forum Discussion

HEATConsultant's avatar
Occasional Contributor
6 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!

2 Replies

  • selva29's avatar
    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