Skip to main content

02a/ Query DB for people to pay

This job was provided by an OpenFn.org user via the job library API.

Metadata

  • Name: 02a/ Query DB for people to pay
  • Adaptor: @openfn/language-mysql
  • Adaptor Version: latest
  • Created over 4 years ago
  • Updated almost 4 years ago
  • Score: 0 (an indicator of how useful this job may be)

Key Functions

alterState

Expression


sqlString(state => {
// stored procedure will return a list of names, phone numbers (MSISDN), and salary info for employees that should be paid today
return 'CALL get_employees_to_pay();';
});

//alterState(state => {
// Note: we pluck out on the 'RowDataResponses' from the SQL server.
// state.data.records = state.response.body[0];
// return state;
//});