Thanks Patrik.
This was really the issue. I have not mapped all the attributes in the response mapping & I think most importantly the Account ID was missing. Once I added it, it fixed the issue.
Although it not the same for all APIs, as I have previously done without mapping all available attributes in the response mapping. Seems it depends API to API.
Thanks Patrick, and all other for your inputs. Really appreciate.