Using action "Invoke Web Service", i'm returned a JSON output (works fine..)
In the end, the data is to be inserted in a SQL database, so using action "Convert JSON to Custom Object", i'm turning the JSON into a custom object.
My data now looks like this:
{
"name": "Donald Duck",
"isCompany": "",
"vatNumber": "",
"cellPhoneNumber": "",
"phoneNumber": "",
"email": "",
"comment": "",
"categoryReference": {
"name": "",
"id": "3000",
"externalId": "3000"
},
"billingAddress": {
.... rest of data is cut off and not included in this post
On my way towards the SQL insert, i am using action "Set Variable" = '%JsonAsCustomObject.name%' (which works fine, the variable is set correctly to "Donald Duck")
but..
Using action "Set Variable" = '%JsonAsCustomObject.email%' will returns this error: "Variable 'JsonAsCustomObject' doesn't have a property 'email'."
How do i get to the point where i can make PAD understand to pick up the value "NULL" or "BLANK" when my Custom Object does not hold a value ?
