Profile

Hello,  Yes it is possible. The way I have mine working is to us a generate rows step containing the URL, Authorization, accept and content type strings, I then feed those to the rest step, that returns a JSON response where I use a JSON step to parse the data into separate fields that I can format ...

I have figured it out! one of the options in the table output step is return unique ID. So I pass the data to the Table output step, write something like their name or whatever to the Name column and Mysql auto increments the ID column, I then select that return Unique ID and pass that along to a formula ...

SO for my instance maybe I am thinking of it backwards. We create email accounts with a users initials and then a 5 digit ID. If I could get it to work in this manor I would have to write the initials to the database first so that the sequence would assign its ID and then re-query the database to pull ...

I think we are mis-understanding each other :), I What I am trying to do is use the add sequence step so that on Monday Susies info comes along to create an account with 50219 as an ID and then on Thursday Tommys info comes down the line to create his account with 50220, So basically I want it to query ...

Thanks Ana, I am not super familiar with the add sequence. Can you give me an example of using a MySQL database to generate the ID? I created a Schema and Set the auto_increment attribute but when I go to query that with the add sequence I cant figure out what the sequence name is that the step is looking ...

Is there any way to use a counter to add a unique number to an output.   I am trying to use Kettle to create some unique IDs for user accounts so I need a way to have a starting number, and every time it runs increment that number by one and never use any numbers over again. I am not sure of the best ...

I was able to figure it out. I think part of the problem was that the data grid step I was using to provide my mail details only provides the details for one line. And each line is a separate email with the Mail step it was only providing an address to the first line. I changed from Datagrid to add constants ...

I am having trouble with a mail step within a transformation. I have configured all of the email fields and the email actually sends just find but Spoon throws an exception saying the Mail Destination empty, This is connected with a gmail gmail account for auth. Here is the actual error text. 2019/08/28 ...