I’m trying to name a spreadsheet based on a dictionary value per the documentation on this page: Writing to Dictionary
I’m getting a " Dictionary doesn’t contain valid value for the key" error.
My dictionary entry looks like this:
and the File URL on my SpreadsheetDataWriter looks like this:
When I try to run the graph, I get this error:
What am I doing wrong?
Hi Bob,
The issue here is that you’ve added the .xlsx suffix in conjunction with dictionary form or URL definition. So what happens is that during runtime the URL is parsed based on the colon characters and you’ve effectively tried to use a “source.xlsx” as the processing type/mode. While it cannot be found during runtime, the default type (stream) is used and the graph fails.
The solution is to remove the suffix from the URL and specifying the “Type of formatter” property of the component.
Kind regards,
Lukas
Thanks. That solved the problem.