Depending on the data format, you should be able to do that using an HTTP Action in a Rule and then save the resulting value to variable.
If you want to share the URL you’re working with and the field (path) you are trying to extract, I’d be happy to put together an example for you.