When I retrieve an O365 site's list's items in the designer workflow (2013) using rest api call, the Number type columns always get set to local integer variables as zeros. I have inspected the returned JSON using the Postman and Advance REST Client tools and there are non-zero values being returned, but when I copy the values to local integer variables and try to log those local variables then all I see are zeros in the workflow history list. Has anyone else experienced this?
not sure what happened, but I had to delete the "Get an item from a dictionary" action items and re-insert new ones and that fixed the problem. Buggy SP Designer wasted my two days :(
This is what the path for the dictionary item looked like in that action item: ([%Variable:index%])/MyNumricListColumn All this time I made sure that the local variable [%Variable:index%] was in fact a correct field data (judging from the way it responded to mouse clicks) and not just any plain text.
I hope this will be a lesson for others too. When in doubt, remove the action item and add it back in, no matter how correct it looks.