We have created web services to return data in JSON format via a web service call. For now the web service has a component which has a JDBC reader step with ‘SELECT * FROM’ query on an underlying database table.
We have 4 such web services on 4 separate tables. 3 of the web services work in Postman. However, the 4th one does not bring back any results (Postman hangs). The table for the 4th web service has the most rows (approx. 187K).
Has anyone encountered such an issue before, and if yes, how was it resolved?
Also, how do I call this web service from excel (instead of Postman)?