I have a problem when I retrieve the data by in_TransactionItem.SpecificContent(“num_doc”).ToString. If I look in the queue the data appears correct 7202122951679869, but when I put it in the num_doc variable it changes to “7.20212295167987E+15”.
I don’t know if it’s related, but this data is in the database as bigInt.
I managed to get around the problem. Forcing to concatenate a letter with a number in the select in the database. This caused the number to be interpreted by uipath as a string.
from [bdp].[dbo].[compr]
where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009)
and dsc_stat = ‘CONCLUIDO’
order by dat_hora_ult_alt desc