Process modeler SDK

var SF = {
  collection : Object,
  user : Object,
  file : Object,
  utils : Object,
  sql : Object,
  instance : Object,
  task : Object,
  process : Object,
  mode : String, // The current Mode this is setted automatically
};

let id = await SF.utils.nextValue("leave_request");
// return number 1
let id = await SF.utils.nextValue("leave_request",5);
// return string 00001

let result = await SF.utils.shellExecLocal('echo Hello World');
// returns: { data: 'Hello World' }

let result = await SF.utils.shellExecLocal('pwd');
// returns: { data: '/home/user/project' }

let result = await SF.utils.shellExecRemote('ls -l', {
  host: '192.168.1.10',
  port: 22,
  username: 'user',
  password: 'password'
});
// returns: { data: 'list of files and folders...', code: 0 }

let id = SF.utils.axios.get('/data/json/123')
  .then(function (response) {
    // handle success
    console.log(response);
  }).catch(function (error) {
    // handle error
    console.log(error);
  });

await SF.collection.insertMany("cost-centers",[{label : "IT", value : "it"}])

await SF.collection.insertOne("cost-centers",{label : "IT", value : "it"})

await SF.collection.findOne("cost-centers",{value : "it"})

await SF.collection.find("cost-centers",{value : "it"})

await SF.collection.updateOne("cost-centers",{value : "it"})

await SF.collection.update("cost-centers",{value : "it"})

await SF.collection.count("cost-centers")

await SF.collection.deleteOne("cost-centers")

await SF.collection.delete("cost-centers")

let aggregation = [
  {
    "$match": { "type": "type1" }
  },
  {
    "$project" : {
                    "_id": 1,
                    "name": 1
                  }
  }
]
await SF.collection.aggregate("cost-centers",[aggregation]);

await SF.collection.cleanCollection("cost-centers")

let bulkOps = [
  { insertOne: { document: { name: 'John', age: 30 } } },
  { updateOne: { filter: { name: 'John' }, update: { $set: { age: 31 } } } },
  { deleteOne: { filter: { name: 'John' } } }
];

await SF.utils.bulkWrite('users', bulkOps);
// returns: Promise resolved when all operations are completed

await SF.user.getUsersinGroup("6042551d231e8c8ade19bc09")

await SF.user.getUsersInGroupList(["6042551d231e8c8ade19bc09","6040e3679c81cf1b60b698f4"])

let group = await SF.utils.getGroupById("60c72b2f9f1b2c3c8f3b8b0b");
// returns: { _id: ObjectId("60c72b2f9f1b2c3c8f3b8b0b"), name: 'Admin', members: [...] }

let group = await SF.utils.getGroupById("60c72b2f9f1b2c3c8f3b8b0c");
// returns: null (if group with this ID doesn't exist)

await SF.user.getUserById("6042551d231e8c8ade19bc09")

await SF.user.getUserByMail("test@softydev.com")

await SF.user.updateUserById("6042551d231e8c8ade19bc09",{firstName : "test"})

await SF.user.updateUsersEach([{ _id: "6042551d231e8c8ade19bc09", payload: { firstName: 'firstUser' } }, { _id: "6042551d231e8c8ade19bc10", payload: { firstName: 'secondUser' } }])

await SF.user.updateUserMetadataById("6042551d231e8c8ade19bc09", "Manager",  "test")

await SF.user.getUsers()

await SF.user.getUserMetadata("6042551d231e8c8ade19bc09")

await SF.user.addUserToGroup("6042551d231e8c8ade19bc09", "62c2b6f74d16c2a2c19dcdb7")

await SF.user.removeUserfromGroup("6042551d231e8c8ade19bc09", "62c2b6f74d16c2a2c19dcdb7")

let user = {
  email: "email@softydev.com",
  lastName : "last name",
  firstName: "first name",
  group: [],
  metadata: {},
  ideAccess: true,
  blocked: false
}
await SF.users.createUser(user);

const file = new File(gridfsBucket);

let result = await file.getFileContentById("64bfa28cfabc123...", "utf8");
console.log(result.content);

let buffer = await file.getFileBufferById("64bfa28cfabc123...");

await file.generatePDFFromTemplate(null, 'templateId', {
  variables: { name: "John" },
  SF_pdfName: "user-report.pdf"
});

await file.createFileFromBuffer({ filename: "doc.txt", contentType: "text/plain" }, Buffer.from("Hello"));

let result = await SF.utils.deleteFileById("60c72b2f9f1b2c3c8f3b8b0b");
// returns: { deleted: 1 } (if file was deleted)

let result = await SF.utils.deleteFileById("60c72b2f9f1b2c3c8f3b8b0c");
// returns: { deleted: 0 } (if there was an error or file not found)

await SF.sql.insertOne("610c0343f6ebc7ddcb49cc3b", "client", {
    code: 'MMA',
    codepostal: 225
})

await SF.sql.insertMany("610c0343f6ebc7ddcb49cc3b", "client", [{
    code: 'MMA',
    codepostal: 225
}])

await SF.sql.findOne("610c0343f6ebc7ddcb49cc3b", "client", "code='MGMT'")

await SF.sql.find("610c0343f6ebc7ddcb49cc3b", "client", "code='MGMT'")

await SF.sql.update("610c0343f6ebc7ddcb49cc3b", "client", "code='MDMS'", {
    code: 'CLEA'
})

 await SF.sql.delete("610c0343f6ebc7ddcb49cc3b", "client", "code='CLEA'")

 await SF.sql.count("610c0343f6ebc7ddcb49cc3b", "client", "code='CLEA'")

await SF.sql.execute('610c0343f6ebc7ddcb49cc3b', "DELETE FROM client WHERE code='KL'")

await SF.instance.launchProcess('610c0343f6ebc7ddcb49cc3b')

await SF.instance.pendingTask('610c0343f6ebc7ddcb49cc3b')

await SF.instance.getMeasures('610c0343f6ebc7ddcb49cc3b')

let variables = {
  "variable1": "value1",
  "variable2": 1,
  "variable3": true
}
await SF.instance.validateTask('610c0343f6ebc7ddcb49cc3b',variables)

let data = {
  "variable1": "value1",
  "variable2": 1,
  "variable3": true
}
await SF.instance.updateVariablesById('610c0343f6ebc7ddcb49cc3b',data)

let result = await SF.utils.attachChildInstance(
  "661e9d8a1a2b2f7f8d3c4e1f",
  "661e9d9b2b5e2f8f8d3c5f0a",
  "step123"
);
// returns: { done: true }

let instance = await SF.utils.getVariablesById("661e9d8a1a2b2f7f8d3c4e1f");
// returns: Full instance document

let instance = await SF.utils.getVariablesById("661e9d8a1a2b2f7f8d3c4e1f", { variables: 1 });
// returns: { variables: {...} }

let result = await SF.utils.deleteInstanceById("661e9d8a1a2b2f7f8d3c4e1f");
// returns: { acknowledged: true, deletedCount: 1 }

let result = await SF.utils.deleteManyInstances("661e9d8a1a2b2f7f8d3c4e1f", { status: "completed" });
// returns: { acknowledged: true, deletedCount: 5 }

let result = await SF.utils.updateInstanceVariables("661e9d8a1a2b2f7f8d3c4e1f", {
  amount: 1500,
  dueDate: "2025-05-30"
});
// returns: { done: true }