We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

HEATConsultant's avatar
HEATConsultant
Occasional Contributor
8 years ago
Solved

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!

  • richie's avatar
    richie
    8 years ago

    Hi HEATConsultant,

     

    check the other post you submitted - I've answered that one.

     

    The change to those instructions to source from a database is to specify 'Data Connection' rather than 'directory'.

     

    Obviously you'll have to tailor the query appropriately to pick up the records you need - check out the following link https://support.smartbear.com/readyapi/docs/testing/data-driven/types/connection.html

     

    Cheers,

     

    richie

2 Replies

  • richie's avatar
    richie
    Community Hero
    8 years ago

    Hi HEATConsultant,

     

    check the other post you submitted - I've answered that one.

     

    The change to those instructions to source from a database is to specify 'Data Connection' rather than 'directory'.

     

    Obviously you'll have to tailor the query appropriately to pick up the records you need - check out the following link https://support.smartbear.com/readyapi/docs/testing/data-driven/types/connection.html

     

    Cheers,

     

    richie

  • selva29's avatar
    selva29
    Occasional Contributor
    8 years ago

    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