Forum Discussion

BartVW's avatar
BartVW
Icon for Helper I rankHelper I
1 year ago
Solved

Enhanced refresh api status 202 OK but dataset is not refreshing

I'm calling the enhanced refresh API with this simple body

{

    "retryCount": 3
}
 
I get a 202 Accepted response (in Postman), but the data set is not refreshing. 
 
As you can see in below screenshot, if I do the exact same call without the body (ie normal refresh), it works and takes about 2 minutes. If I add the body, it says it works but finishes in few seconds without a refresh.

 

Does anyone have any idea what might be wrong?
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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".

4 Replies

    • BartVW's avatar
      BartVW
      Icon for Helper I rankHelper I
      1 year ago

      Thanks @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
        }
    ]
}
      • BartVW's avatar
        BartVW
        Icon for Helper I rankHelper I
        1 year ago

        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?