Forum Discussion
Helper IEnhanced refresh api status 202 OK but dataset is not refreshing
Yes, "automatic" will check if there is anything to refresh. If the service decides that nothing has changed it will not refresh the partition. You can override that with "full".
Helper IThanks @lbendlin
This is the request status I get. I don't really see anything that tells me why it is not working. Would you have any idea?
{
"startTime": "2024-11-26T09:34:21.513",
"endTime": "2024-11-26T09:34:30.433",
"type": "Automatic",
"commitMode": "Transactional",
"status": "Completed",
"extendedStatus": "Completed",
"currentRefreshType": "Automatic",
"numberOfAttempts": 0,
"objects": [
{
"table": "DateTableTemplate_4db2717a-c750-4e65-aa7e-944ab850ff2f",
"partition": "DateTableTemplate_4db2717a-c750-4e65-aa7e-944ab850ff2f",
"status": "Completed"
},
{
"table": "Source data",
"partition": "Source data",
"status": "Completed"
}
],
"refreshAttempts": [
{
"attemptId": 1,
"startTime": "2024-11-26T09:34:22.5574511Z",
"endTime": "2024-11-26T09:34:30.4328433Z",
"type": 0
}
]
}Having said the above, I played around a bit more with the POST request body. I found that if I include
"type": "Full"in the body, it works OK. So it seems the default type "Automatic" is not doing anything.
Not sure if this makes sense though, as the documentation says "Automatic" is the default?
- lbendlin
Super User
Yes, "automatic" will check if there is anything to refresh. If the service decides that nothing has changed it will not refresh the partition. You can override that with "full".