Skip to main content
H
harikumarm0002
January 30, 2024
Question

Expose data to external system

  • January 30, 2024
  • 8 replies
  • 0 views

Hi All ,

Need to send the data from appian to external system and set flag to yes for all the rows which has been sent successfully in Appian table to ignore these rows for next set of data to send. What is the best way to do this.

    8 replies

    G
    ganeshsasankg0395
    January 30, 2024

    Can i know how you are filtering data 

    jayaprakashr0001
    jayaprakashr0001
    Participating Frequently
    January 30, 2024

    Hi [mention:c58a082455fc46329dc2db9a89ad1ca4:e9ed411860ed4f2ba0265705b8793d05] ,

    Can you tell how you are passing , Assuming you are using queryrecord() you can have the filters and you can pass the required data to external system

    H
    harikumarm0002Author
    January 30, 2024

    i am using expression rule to fetch the data from DB  here applying some filters( related this data UI user can edit n number of times they can able to changes that many times sending data to external system). so if i set the flags if user not change anything will avoid that cases/ requests

    harshitb6843
    harshitb6843
    January 30, 2024

    If you are calling this integration from the process model, you can simply update the rows you fetched earlier to send, set the flag, and update them back in the DB. 

    If you are doing it from the interface, you can use the integration rule's onSuccess parameter to call a!writeToDataStoreEntity or a!writeRecords and it should do the work. 

      H
      harikumarm0002Author
      January 30, 2024

      Hi Harshit ,

      we are using  GET web api call smart services are not supporting

      harshitb6843
      harshitb6843
      January 30, 2024

      You are sending rows using a GET API?

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      January 30, 2024

      When we talk about implementing a web API that other systems can call to query data, I recommend to not store any data locally, but to let the other system decide what to put into the response. A frequently used approach is to add paging info like start index and batch size to the call. Then you API can fetch the requested data and send it back.

      Terms & ConditionsAccessibility statement