API GET Request with database

[Marek_Melocik]

Hello,

for updating GET requests, use the same approach as described here

In this case, you may use foreach loop to send requests for all DB rows. Pseudocode:

List<GroovyRowResult> res = sql.getSelectResults('SELECT TOP 10 PERSONAL_ID, PHONE2 FROM CLIENTS WHERE PERSONAL_ID IS NOT NULL AND PHONE2 IS NOT NULL')

	for(Map oneRow in res) {
		String personalId = oneRow.get("PERSONAL_ID")
        String phone = oneRow.get("PHONE2")
        // use variables in the GET request here
	}