Record type data not syncing due to error in batches

Question

Hello! 
 I am working with an API response from BigQuery, I get the data to be on the record type from my input rule, however when I try to sync, it keeps getting an error as shown below

So, I'm not able to work with this record because of the error, I checked this article https://docs.appian.com/suite/help/21.3/configure-record-data-source.html and it seems like I have to modify the batch number rule but I'm not sure how to do it (like what I have to put in there) or if that is even the issue. My response gives a 632 record only so it is less than 1000, and I assume I shouldn't have to do sync in batches as is less than 1000, but still the error comes up, have you encountered this error or do you guys have any input on how to solve that?

Peter Lewis · Answer

There's two options when performing a sync with a web service: 
 
 Sync all of the data in a single batch 
 Sync in batches up to 1000 
 
 You mentioned you have 632 records - do you expect that it will always be less than 1000? If so, you don't need to use batches at all. Just remove the rule input from your source expression and the record sync will assume all of your data is returned in a single batch. 
 If you expect that your data could grow to more than 1000 rows, then you will need to configure batches. The easiest way to do this like Stefan said is to return an empty set or null if there's no data. 
 So one common approach would be something like this: 
 a!localVariables(
 local!data: rule!MY_Rule(batchNumber: ri!batchNumber),
 if(
 or(
 isnull(local!data.result.body),
 length(local!data.result.body)=0
 ),
 {},
 local!data.result.body
 )
)

Record type data not syncing due to error in batches

Top Replies