Using dictionary entry to name a spreadsheet file

Bob Shuka

• June 16, 2023 20:14

Follow

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?

• 

  Lukas Cholasta

  • June 21, 2023 14:46
  • Edited

  • Official comment

  Comment actions Permalink

  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

• 

  Bob Shuka

  • June 22, 2023 21:23

  0

  Comment actions Permalink

  Thanks. That solved the problem.

Please sign in to leave a comment.