Skip to main content

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

Be the first to reply!

Reply