Skip to main content
Known Participant
Aug 11, 2023 2:04 PM UTC
Question

Data gets updated in db but in record it is not getting synced

I have excel sheet from which all data gets uploaded in db via smart service import excel to db but in record it is not getting updated immediately . I need to sync manually everytime to see the new records.


Can someone please help me with this how to sync data immediately .

    4 replies

    mathieud0001
    Genius
    Aug 11, 2023 2:54 PM UTC

    Just tested it and it does seem as though the plugin does not support synced record types. I would suggest you reach out to the plugin author here: https://community.appian.com/b/appmarket/posts/excel-tools

    In the meantime, you can use the readexcelsheetpaging() function in conjunction with the Write Records Smart Service to get around this issue.

    mikes0011
    Brainy
    Aug 11, 2023 3:08 PM UTC

    When you say "sync manually", what exactly are you doing to accomplish that?

    What does your process look like?

    The Expression Guru
    abhayd3663
    Brainy
    Aug 11, 2023 3:38 PM UTC

    Do you have record sync enabled?

    sabat0002Author
    Known Participant
    Aug 14, 2023 12:12 PM UTC

    yes it is enabled