cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

175
Views
0
Helpful
1
Replies
Beginner

CCX Script DB Read Result from a Stored Procedure into a Variable

Afternoon all,
Logically, this feels like it should be an extremely easy thing to do.
I've called a Stored Procedure via DB Read and successfully returned the result that I need (number of rows returned = 1). I then want to take that result and toss it into a Variable to be used later on down in my script.

The process basically takes the caller's number and tosses it into the stored procedure to give us an account number (the returned row). How do I access that returned result to assign it to a variable?

1 REPLY 1
Beginner

Re: CCX Script DB Read Result from a Stored Procedure into a Variable

I think I would approach it like this:

Define an empty string variable.

Set (Variable name) on successful DB GET step

Or if passing to finesse or another script, set enterprise call info step (variables used)

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards