Share
ReportI'm running into 3 intrerrelated issues trying to get entities working with excel spreadsheets:
1. I select 'Get data', go through the steps, select the sheet, set headers, primary key, etc.
during the 'create' process, I get this error:
"Load to Common Data Service failed. Details: [(([Table with name 'crca0_miscequipment_3s' does not exist], The remote server returned an error: (404) Not Found.), Unable to retrieve metadata for CRM environment: https://canada-001.azure-apim.net/apim/commondataservice/f5b08057b4ae457fb6ac65a34b196285/$metadata.json/datasets/default.cds/tables/crca0_miscequipment_3s)], One or more errors occurred.. (Job ID: cb67a036-4ddc-42dd-b38e-099312aad045)"
2. When I get the above process to work (maybe 1 time in 20), the entity that's created always seems to be using a cached version of the sheet; I've tried modifying sheet/column names in case they were causing problems, and I see references to previous names in newly-created entities.
3. Even on the rare occasion that the app actually worked, I found that the app would not display new data entered
through Excel. This tells me that the app has cached some data somewhere, and is using that, even though I use Refresh() frequently.
What am I missing?
All responses (
Answers (
542
