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 about 5 years ago
  • Updated over 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;
//});