Forum Discussion

Salvatore_Pirre's avatar
Salvatore_Pirre
Occasional Contributor
15 years ago

[RESOLVED] Datasink Question

Hi,

I created a spreadsheet datasink that picks up data from the response message. I noticed that if a field is returned blank
<m:unitNumber/>
this is put in the spreadsheet
<m:unitNumber xmlns:m="http://xxx/bwsgservices/schema/version/2.5/bsos"/>
. Is there anyway to have this cell left blank if no value is returned?

thanks

spirrello

2 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    Hi!

    are you using a property-transfer or property-expansion? In either case, do you have the "/text()" axis specified in your xpath statement?

    regards!

    /Ole
    eviware.com
  • Salvatore_Pirre's avatar
    Salvatore_Pirre
    Occasional Contributor
    This was fixed by entering the "/text()" axis. i put this on each property to make sure.

    thanks