Skip to main content
R
riyak9492
October 30, 2024
Question

Can bigint in SQL be mapped in appian?

  • October 30, 2024
  • 6 replies
  • 0 views

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
    shanmathip7466
    October 30, 2024

    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

    R
    riyak9492Author
    October 30, 2024

    Thanks!

    somasundaram.d
    somasundaram.d
    October 30, 2024

    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.

    R
    riyak9492Author
    October 30, 2024

    Thanks!

    parthasarathym6661
    parthasarathym6661
    October 30, 2024

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

    R
    riyak9492Author
    October 30, 2024

    Thanks!

    Terms & ConditionsAccessibility statement