Genesys Cloud - Main

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

What error (if any) do you get? Are you using a Data Action? If so, what happens when you try running it in test mode with data like this?
It may be necessary to put quotes around the data....

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Easiest solution is to reimport your list with CityName or City_Name and then transform City Name to one of those before running data action.  

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

The column name in Contact List is CityName, without space, as indicated, if i execute directly via Actions, it inserts successfully but via Call Flow it fails

Easiest solution is to reimport your list with CityName or City_Name and then transform City Name to one of those before running data action.  

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Must have come across with spaces on my side.  Probably autocorrect.  

Anyway, are all the inputs to the Data Action string or do you have other input tyoes?

The column name in Contact List is CityName, without space, as indicated, if i execute directly via Actions, it inserts successfully but via Call Flow it fails

Easiest solution is to reimport your list with CityName or City_Name and then transform City Name to one of those before running data action.  

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

The column name in Contact List is CityName, without space, as indicated, if i execute directly via Actions, it inserts successfully but via Call Flow it fails

Easiest solution is to reimport your list with CityName or City_Name and then transform City Name to one of those before running data action.  

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

The only thing vaguely "fishy" that I can see is that the address is "Western Cape" "Cape Town".
You indicated earlier in the thread that the issue only arose when you had a space in the City Name and I suggested surrounding the data with quotes, which I assume is what you did. Looking at the Data Action export, I think this is now getting expanded out to
"Address": ""Western Cape" "Cape Town""
which would be problematic. Try using single quotes in the data, so it expands to
"Address": "'Western Cape' 'Cape Town'"
HTH

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi there, thanks for response, i have tried all these options and still fails

The only thing vaguely "fishy" that I can see is that the address is "Western Cape" "Cape Town".
You indicated earlier in the thread that the issue only arose when you had a space in the City Name and I suggested surrounding the data with quotes, which I assume is what you did. Looking at the Data Action export, I think this is now getting expanded out to
"Address": ""Western Cape" "Cape Town""
which would be problematic. Try using single quotes in the data, so it expands to
"Address": "'Western Cape' 'Cape Town'"
HTH

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Try this:  use %20 instead of space

Hi there, thanks for response, i have tried all these options and still fails

The only thing vaguely "fishy" that I can see is that the address is "Western Cape" "Cape Town".
You indicated earlier in the thread that the issue only arose when you had a space in the City Name and I suggested surrounding the data with quotes, which I assume is what you did. Looking at the Data Action export, I think this is now getting expanded out to
"Address": ""Western Cape" "Cape Town""
which would be problematic. Try using single quotes in the data, so it expands to
"Address": "'Western Cape' 'Cape Town'"
HTH

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

hi thanks, i will attempt this but as this will be an email sent into system i will have to detect/replace any space with%20.
replace(Address, " ", %20) correct?

Try this:  use %20 instead of space

Hi there, thanks for response, i have tried all these options and still fails

The only thing vaguely "fishy" that I can see is that the address is "Western Cape" "Cape Town".
You indicated earlier in the thread that the issue only arose when you had a space in the City Name and I suggested surrounding the data with quotes, which I assume is what you did. Looking at the Data Action export, I think this is now getting expanded out to
"Address": ""Western Cape" "Cape Town""
which would be problematic. Try using single quotes in the data, so it expands to
"Address": "'Western Cape' 'Cape Town'"
HTH

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

Hi there, yes that is a Boolean to set the contact as callable or not.

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

Hi there, thanks for response, i have tried all these options and still fails

------------------------------
Reginald

Original Message:
Sent: 05-08-2023 15:33
From: Paul Simpson
Subject: Insert data into Contact List

The only thing vaguely "fishy" that I can see is that the address is "Western Cape" "Cape Town".
You indicated earlier in the thread that the issue only arose when you had a space in the City Name and I suggested surrounding the data with quotes, which I assume is what you did. Looking at the Data Action export, I think this is now getting expanded out to
"Address": ""Western Cape" "Cape Town""
which would be problematic. Try using single quotes in the data, so it expands to
"Address": "'Western Cape' 'Cape Town'"
HTH

------------------------------
Paul Simpson
Eventus Solutions Group

Original Message:
Sent: 05-08-2023 14:52
From: Reginald Sheraton
Subject: Insert data into Contact List

Hi there, yes it takes failure path and receive these errors: Error Status = 400; Error Code = BAD_REQUEST
I have added as Participant data and can confirm all is in order, i have set all variable defaults to Null in Call Flow and in Data Action to accommodate any blank info. i have attached screen shot of participant data.
I sent an email with the below in the body:
Mr|Test1|Test2|Test3@mweb.co.za|Test4|0112057107|123456789|"Western Cape"|"Cape Town"|2023-05-08|
in the Call flow i append(Mr, Test1, Test2) and write to CustomerName in Contact List. Also Append(Western Cape, Cape Town) and write to Address field in Calling List. as soon as i add Email or Address variable to write to Calling List it fails, if i remove these 2 the info is written into Calling List. If i go to the action within Genesys and enter all the above info and Click RunAction, all info is written into the Calling list including email and Address.

------------------------------
Reginald

Original Message:
Sent: 05-08-2023 13:51
From: Paul Simpson
Subject: Insert data into Contact List

@Reginald Sheraton you describe it as failing. How do you know? Is it just that it follows the failure path and / or the data doesn't show in the list?

Are you capturing the error error message and if so, what do you get?

I would begin by writing all the parameters you are passing to the Data Action, to Participant Data and then looking at what is actually there. Is it possible one of the variables is unexpectedly blank and throwing the REST call off? Maybe you have a typo in a variable name? Take a look at the variable list for the flow and see if there are any that appear duplicated, but one has a typo. Or maybe you have Task variables that are being set in one task and the Data Action is in a different task? (The value won't transfer.)

------------------------------
Paul Simpson
Eventus Solutions Group

Original Message:
Sent: 05-08-2023 13:12
From: Reginald Sheraton
Subject: Insert data into Contact List

Hi there, yes that is a Boolean to set the contact as callable or not.

------------------------------
Reginald

Original Message:
Sent: 05-08-2023 13:06
From: Robert Wakefield-Carl
Subject: Insert data into Contact List

What about this one:

          "ContactCallable": {            "type": "Boolean"          }

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 05-05-2023 05:57
From: Reginald Sheraton
Subject: Insert data into Contact List

Hi all,
i have a very strange issue and would appreciate assistance.
i receive data via email into Gen Cloud in the below format:
Ms|John|Soap|LSoap@gmail.com|1234567890|9874563210|201320|City Name|State Name|2023-05-05
in the email flow we then split (Split(Flow.Body, "|") the above data and assign to individual variables.
these variables are then used in a data action which inserts the values into a Calling List.
the problem we have is when split [7] "City Name" has a space in the value, it fails to insert into the Contact List.

once the split [7] has no space "CityName" the record is successfully inserted into Contact List.

any suggestions to overcome this???????

#Outbound

------------------------------
Reggie
------------------------------