Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to connect to an OData XML source, but it has pagination in the form of "next url".
However, there are two "next url" fields in the data source, and when adding the path to the "next url" field (feed/link/attr:href) it always gets the first value, when the real "next url" is located in the second link element.
I've tried to use
feed/link[1]/attr:href, but it won't work, I've also tried editing the select script in the data load editor with a where clause, but it just gives an unexplained error, probably because xml sources do not support where clauses with the REST Connector...
Any ideas?
Where you able to get this resolved? Stuck with the same issue.