Connector

Hello,

I have some stored procedure at Microsoft SQL Server, it returns a view ('myview') based on parameters passed:

The stored procedure ('requserinfo') has 3 parameters: @fname; @lname;@locationcode .....

I want to use the procedure to get a user information in the form (something like: FirstName, LastName, Age, Location etc). It is going to be some kind of a search form... I don't have an access to the data source, only can execute the procedure so this is only the way to get the user information....

hi ;
i create a connector with bonitasoft to Mysql workbench 8.0.16:
when i test, i get this message:

Hello,
I am working on developing a membership assignment process.
admin can create multiple memberships of multiple users.

Until now, I couldn't find a proper API regarding the function.
Identity API is working with one user and one membership each.
I created a SQL connector and send query statement parameter to implement.
It is working well. However, I need to manipulate the table and put some dummy data.

I want to get data from the database and display it on the WEB screen table.

However, although it seems to use DB connector for the entrance connector, I do not know what to do in "definition of output operation".

Can you tell me what to do?

Hello,

I created an email connector with attach files and it works well.

When I attach the file, it works well. However, once I didn't attach the file, it has an error.

I validate formOutput like :

if($data.formInput.authdocumentDocumentInput){
return {
'authdocumentDocumentInput': $data.formInput.authdocumentDocumentInput
};

}else{
return {
'authdocumentDocumentInput': null
};
}

But, the error occurred when I didn't attach the file.

Hello,
I have many email connector in my process. all connectors are working well.
Then, I created an email connector has a message with groovy script.

In the script, I would like to get the reason from bdm. the code is as below,

Hi guys,

Is this possible to change the Log Level for the SQL Datasource connector ?
I think in the code it might write INFO messages (Request and Results ...)

1- Should I make a product update request for it to be set to DEBUG ?
2- If let to INFO, is it possible to change the Logging config for this connector Specifically :
2a - in the Studio ?
2b - on the Server once deployed ?

Thank you for your answers :)
Pierre

Hello,

I wonder if someone in the community can offer me some advise. I have built a new plugin for Google sheets and it fails during testing with the message: "For unserialization output, you can transform it into a serializable object using the output editor." I have a screen capture but I'm not sure how to attach it.

Thank you.

.

Hello everyone.

I have a connector that insert a row in an external mysql db that works correctly. Now, I wanted to extend such connector in order to return the id of the lastly inserted row (the mysql table has a auto_incremented field) which I want to save in a variable to use it for future editing within the same process (I do that in the output operation definition part of the connector). The groovy code looks like this: