How to get bigInt number more than 15 characters from the database and put it in a string

Hi guys, thanks a lot for the tips.

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.

Look

select id,cnpj, num_doc_ajustado = concat ([num_doc],‘a’), data_hora, razao_social, local_arq

from [bdp].[dbo].[compr]
where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009)
and dsc_stat = ‘CONCLUIDO’
order by dat_hora_ult_alt desc

image

1 Like