How to extract null data from queue

[Sandhya_Gajare]

Hi team,
I am extracting data from queue in queue i have candidate name email id and REQID is present for some record i have candidate name and email address but REQ is empty i am trying to fetch that but its show error

in screenshot how can i handle this can anybody help me out on that

[Anil_G (Anil Gorthi)]

@Sandhya_Gajare

queue

@Sandhya_Gajare

First check if there is a value or not as below

IsNothing(in_Transaction_Item.SpecificContent("REQID")) This will return true if there is no value

cheers

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Sandhya_Gajare use try catch and if exception occurs update strReqid as Null

[Sandhya_Gajare]

Process.xaml (9.5 KB)
I am sharing here code

[Anil_G (Anil Gorthi)]

@Sandhya_Gajare

You can use thw above expression in an if condition before assigning and it would give true or false

Cheers

[Sandhya_Gajare]

can you give me example please bz in code now my code is able to extract the all record if they are in queue issue or exception throw if REQ is null give xml of it if possible for you

[Sandhya_Gajare]

@Anil_G

IsNothing(in_Transaction_Item.SpecificContent(“REQID”))

queue item is object type whille writing condition in if loop we need to convert to boolean is it

[Anil_G (Anil Gorthi)]

@Sandhya_Gajare

This will give true or false only…IsNothing function will check if the provided object has data or not

Cheers

[rikulsilva (Henrique Lima da Silva)]

Hi,

You can check if specific content has the REQID before assign:

If specific content has the key, then assign … if not, assign empty string

[Sandhya_Gajare]

key mens what i have to do

[Sandhya_Gajare]

I have queue with candidate name, emailid,REQID but sometines my REQID is empty
i am trying to access that using simple assign activity but if my transcation item REQID is empty for that i am getting an error so if there is not REQID i expect to print candidate name and email address and for REQID null

[Anil_G (Anil Gorthi)]

@Sandhya_Gajare

Change the asiagn activity like this

Reqid = If(IsNothing(in_TransactionItem.SpecificContent("ReqID")),"",in_TransactionItem.SpecificContent("ReqID").ToString)

This will assign blank if no value is there else the value that is present is assigned

Hope this helps

Cheers

[Sandhya_Gajare]

I will check this

[Sandhya_Gajare]

Thanks Anil Work for me