I have set up the connector in Designer, however I have no idea what to do next. My output when I run is two blank columns (JSON_Name and JSON_ValueString). It does not allow me to input the reference and I am at a stand still. I am hoping to pull multiple reports across different client bases and I am wondering the best way to do this.
For example if I pull directly into PowerBI from QuickBooks it gives me my entire client list and any report available.
I have all of that information and have it populated within Designer. I can click run and I see on the Intuit Developer side that we have established a connection. My question is what to do next. I cannot figure out how to pull down Client data (ie. if I wanted to pull a GL report for a client using set parameters. I see in Intuit Developer how to code that, I am just not sure what I am supposed to do to actually extract the data into Designer.
Try entering the above URL in the API Endpoint URL field for the tool as a test. You will need to change the sections in red where after "company/" is your company ID number and the dates will be your start and end date for the query.
I have a same problem no matter what I do I get the the 2 blank columns.
I had a look at the link at how to make the URL and whatever I try I get above. The instructions are not very clear to me as I am a complete novice so I don't quite understand how I am actually meant to construct the URL. All I want is report salesbycustomer with detail for a certain time frame.