Skip to main content
Participating Frequently
Oct 30, 2024 6:11 AM UTC
Question

Can bigint in SQL be mapped in appian?

Hi,

I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

    6 replies

    shanmathip7466
    Inspiring
    Oct 30, 2024 6:29 AM UTC

    HI [mention:9b62ca19c05c4d03ab256749f7eff9e0:e9ed411860ed4f2ba0265705b8793d05] , 

    You can use Text to map those bigint values Since in appian we have only few primitive data types.

    Refer this link docs.appian.com/.../Appian_Data_Types.html

    riyak9492Author
    Participating Frequently
    Oct 30, 2024 12:50 PM UTC

    Thanks!

    somasundaram.d
    Employee
    Oct 30, 2024 7:19 AM UTC

    Appian does not support bigint. Numbers longer than int are converted to ∞. 

    You can use varchar in sql to store the codes and map it to text in appian.

    riyak9492Author
    Participating Frequently
    Oct 30, 2024 12:50 PM UTC

    Thanks!

    parthasarathym6661
    Inspiring
    Oct 30, 2024 10:25 AM UTC

    You can use the text variable in appian to store big int type . Use Varchar in SQL, then map that appian text variable.

    riyak9492Author
    Participating Frequently
    Oct 30, 2024 12:53 PM UTC

    Thanks!