This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.