Hello, hoping someone has experience with the Dataverse add on and can help with a problem I'm running into. As far as I can tell, it is a defect with the tool.
After connecting to my company's Dataverse environment and selecting the table object I want to pull into my workbook, I'm noticing there are columns missing from what passes into the workbook. For instance, the table I'm trying to query has 145 columns but only 97 pull through according to the results panel. I only need around eight columns of the 145, but some of the ones I need are not present in what is coming through. Curiously enough, I can see those column names when I click the drop down and explicitly specify the columns I want to pull in from the table, but when I run the workflow it throws a 400 error.
"Error: Dataverse Input (1): Error code 400: Bad request syntax or unsupported method."
See my snip below for tool configuration. I'm using Dataverse Input tool version 1.2.0
Were you able to figure this out. I'm running into the same issue.
Not yet - might need to submit a support ticket for this one.