Skip to main content
R
ramyad6195
August 12, 2024
Question

Service back records

  • August 12, 2024
  • 6 replies
  • 0 views

Hello Everyone,

We have a use case where in we need to nightly refresh our look up tables( truncate existing data and update if integgration is success)on daily basis.


As our application is record centric I am planning to use service backed record to external system.However I have below questions to clarify before I proceed.

Do we need to hit the API twice? once to check if it’s success and second to populate the record?

To truncate the existing data I am thinking to use delete records.

Also, Unsure how serviceback record handles if integration fails.

Please let me if this approach is suggestable for the above use case.

Thanks in advance.

    6 replies

    Y
    yogip3177
    August 12, 2024

    You can use the 'Schedule full syncs' feature provided by Appian.

    venkatrea696188
    venkatrea696188
    August 12, 2024

    If you want to move to Service backed records , For your case you need to consider the below things.

    To truncate the existing data I am thinking to use delete records.

    I don't think Delete Records is the right option . Write a store procedure which truncates the data . (Delete records works like Delete statement in SQL ,Primary key is not going to start from 1).  

    You need to do Full Sync after , So Make sure timing of Full Sync (Yogi's Suggestion) comes after Schedular .

    Do we need to hit the API twice? once to check if it’s success and second to populate the record?

    There is a limitation on API call for data syncing , You can sync Only 1000 rows for one hit , So you need to process it in batches if data is heavy. Refer Documentation about this. 

     https://docs.appian.com/suite/help/23.1/generate-web-api.html#overview

    Also, Unsure how serviceback record handles if integration fails.

    I think this you can handle it in Web Api expression itself Based  on error codes. 

     

    Y
    yogip3177
    August 13, 2024
    As per documentation, full sync will first purge data. Hence, there is no need to manually delete data. See the screenshot below for reference:
    R
    ramyad6195Author
    August 13, 2024

    Hello [mention:c3d4bf332aba4695885fdc0e0110ec6e:e9ed411860ed4f2ba0265705b8793d05] .Thanks for the reply.It really helps.

    Also,Just to confirm on the below queries as well.

    1.Assuming Purge will happen upon success ,in case of error purge wont happen and exixsting data remains as is.

    2.Do we get any error alert in case of error scenario that we usually get if something break/fails in appian. i tried to look where to configure but could not see the option.

    3.Will the service back records works simlilar to the DB backed records with respective to relationships?

    Terms & ConditionsAccessibility statement