Is there a limit as to the size of the data source I can connect to when doing a REST connection and outputting to XML? For instance, I noticed if I go above 500 items for an Excel file, InfoPath craps out on me. You would think I can make any connection without actually displaying the data.
Also, is there a knowledge source I can refer to when making data connections? The InfoPath books out there don't cover this topic very well (how to make Rest Connections/format type/changing the REST connection/types of output, so on and so forth).