REST API Dynamic Datasource aren't refreshed

Thanks guys, the "relative path" parameter did help me get this issue fixed.  Although I still had further issues with the query.

For anyone who has a similar issue then do this:

1 - Add the Relativepath to the web.contents as described above.  To ensure it uses the same credentials as the original API call, make sure the URL part of the call is the entire URL up to where the parameters start (normally the ? character) and then use the relative path for the parameters (the rest of the URL)

2 - Make sure you make the 2nd API call as soon as possible within the Query ideally after the "Table.ExpandRecordColumn"

3 - Any further changes should be split out into a new query that then has the source of the query above.

If you follow these rules, it should work!

Lee.