I am using
to get the defined ODATA connections in an excel.
“Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=2 auto tables_bananas_6314;Extended Properties=”"",
but not the actual connection info with the external source url.
I would like a method to get all the external source url data that IS available in the included file in a
[customXml] \ [item1.xml] -> (encoded in base64)
odata_query.xlsx.zip (22.9 KB)