Search found 8 matches

by op2352
Tue Jan 28, 2025 2:47 pm
Forum: General Discussion
Topic: Accessing simPRO data using Power BI
Replies: 6
Views: 13882

Re: Accessing simPRO data using Power BI

Hi SimproAPITeam,
Thanks for the above reply. I think I'm out of my depth here, so I am going to put this topic to one side for a while and concentrate on simpler tasks where I hope I can achieve better progress with my limited intellect.
Kind regards,
Gary
by op2352
Wed Jan 22, 2025 5:22 pm
Forum: General Discussion
Topic: Accessing simPRO data using Power BI
Replies: 6
Views: 13882

Re: Accessing simPRO data using Power BI

Hello SimproAPITeam, Many thanks for you reply. Your answer to my question on how to construct endpoint URLs was great, thanks. But I'm not sure whether you answered my question about whether Copilot was correct to suggest that I could use endpoint URLs in Power BI to view simPRO data. Could you ple...
by op2352
Mon Jan 06, 2025 5:16 pm
Forum: General Discussion
Topic: Accessing simPRO data using Power BI
Replies: 6
Views: 13882

Re: Accessing simPRO data using Power BI

Hi SimproAPITeam, Many thanks for your reply. Apologies for the slow response. When I raised the question I ticked the checkbox labelled "Notify me when a reply is posted", so I was expecting an email to alert me if anybody replied (so that I didn't have to keep monitoring this website on ...
by op2352
Fri Dec 27, 2024 9:42 am
Forum: General Discussion
Topic: Accessing simPRO data using Power BI
Replies: 6
Views: 13882

Accessing simPRO data using Power BI

Hello, I’m trying to make use of simPRO's API functionality, but I’m struggling to get started. In particular, I’d like to know what the API endpoint URLs are. In the Help text, the API FAQs page (https://helpguide.simprogroup.com/Content/Service-and-Enterprise/API-FAQs.htm) states: “The API documen...
by op2352
Fri Dec 27, 2024 9:15 am
Forum: General Discussion
Topic: Connecting to simPRO data from Excel
Replies: 6
Views: 8851

Re: Connecting to simPRO data from Excel

Hi Gary, Have you had any success with your excel-Simpro exercise? I have the same problem and would appreciate if you could share what helped you Hi Nadya, So sorry for the slow response. I don't seem to be set up to receive notifications (something I'll need to look into), so I had no idea you ha...
by op2352
Mon Mar 04, 2024 5:24 pm
Forum: General Discussion
Topic: Connecting to simPRO data from Excel
Replies: 6
Views: 8851

Re: Connecting to simPRO data from Excel

Hi dmpchch, Many thanks for taking the trouble to pen such a detailed and useful reply. (I stumbled across it by chance, as the "Notify me when I reply is posted" checkbox didn't work for me.) Unfortunately, I have very little experience of VBA and your code snippet was complex enough for ...
by op2352
Fri Feb 09, 2024 9:03 am
Forum: General Discussion
Topic: Connecting to simPRO data from Excel
Replies: 6
Views: 8851

Re: Connecting to simPRO data from Excel

Hello Sindre, Many thanks for your response. Apologies for not replying sooner - I gave up checking after a week of silence, but simPRO Support kindly alerted me to your response. I've just noticed there's a "Notify me when I reply is posted" checkbox that I failed to tick on my original m...
by op2352
Mon Jan 15, 2024 4:19 pm
Forum: General Discussion
Topic: Connecting to simPRO data from Excel
Replies: 6
Views: 8851

Connecting to simPRO data from Excel

Hello. Apologies for this pretty basic question - I'm new to this ... Could somebody please tell me how I can pull simPRO data into Excel? I have set up an API, which gives me a "redirect URI" and an access token, but I don't know where in Excel to use these pieces of information. I'm assu...