I have a vendor OData feed URL. It works fine in my Power BI, but fails to retrieve the feed in FME desktop (2020.1.3). Below shows the error. I am using the same credential in both Power BI and FME user authentications.
Python Exception <KeyError>: 'name'
A fatal error has occurred. Check the logfile above for details
Failed to obtain any schemas from reader 'ODATA' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information
UniversalReader -- readSchema resulted in 0 schema features being returned
Reader Parameter(0) = >https://data.woodmac.com/query/upstream_weekly/imp-met/odata/field_geospatial_summary<
Reader Parameter(1) = >AUTHENTICATION<
Reader Parameter(2) = >Basic<
Reader Parameter(3) = >USERNAME<
Reader Parameter(4) = >allen.guan<at>bhp.com<
Reader Parameter(5) = >PASSWORD<
Reader Parameter(6) = >********<
Reader Parameter(7) = >VERSION_HEADER<
Reader Parameter(8) = >DEFAULT<
Reader Parameter(9) = >_MERGE_SCHEMAS<
Reader Parameter(10) = >YES<
Reader Parameter(11) = >RETRIEVE_ALL_TABLE_NAMES<
Reader Parameter(12) = >YES<
Reader Directive(0) = >RUNTIME_MACROS<
Reader Directive(1) = >AUTHENTICATION,Basic,USERNAME,allen.guan<at>bhp.com,PASSWORD,********,VERSION_HEADER,DEFAULT,_MERGE_SCHEMAS,YES,RETRIEVE_ALL_TABLE_NAMES,YES<
UniversalReader -- readSchema resulted in 0 schema features being returned
Failed to obtain any schemas from reader 'ODATA' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information