Skip to main content
April 6, 2026
Solved

Queries in Service backed record type

  • April 6, 2026
  • 3 replies
  • 0 views

Hi All,

I have record type which is configured as a service backed record using an expression rule that call an integration to an external system.
Additionally, we have configured the schedule full sync at 12 am daily.

 I have few queries regarding this:
1. Since the record type is service backed, does Appian store any data internally when the scheduled sync runs?
2. will a!queryRecordType() always hit the external system even after the scheduled job runs?
3. If data stores internally, does appian consume memory? if yes how much?
4. If it hits external system every query, what is the recommended approach if we want to avoid repeated API calls and Improve performance?

Any guidance or best practices would be helpful.

Thanks in advance

Best answer by stefanhelzle0001

You answered this question already in the second sentence:

full sync

1) Yes. This is what a synced record is about.

2) No

3) Yes, and depends on the data you store.

4) N/A

3 replies

stefanhelzle0001
April 6, 2026

You answered this question already in the second sentence:

full sync

1) Yes. This is what a synced record is about.

2) No

3) Yes, and depends on the data you store.

4) N/A

varuntejg243705
April 6, 2026

Answers for your queries:

1. When sync is enabled, it will cache the data in appian.
2. Nope, it will get the data into appian cache memory at scheduled sync/manual sync, you can access it directly w/o explicitly calling API.
3. Internally in the sense, data is stored in cache, upto 50 million records, but need to batch the records by 1000(Incremental sync is recommended).
4. As it will not hit, There is no approach for that.

Hope this helps you understand clearly....

shubhama926776
April 6, 2026

Yes, Appian caches synced data internally in Data Service.
No, uses cache unless stale/missing.
Yes, proportional to data volume.
Enable incremental syncs, filter queries, monitor cache; consider DB-backed.