Getting Data Out

[mrrodge]

@mrrodge

Update for anyone interested - it's taken me a VERY long time but I've been able to use the Central API to get whatever I want from Central, with the exception of images/attachments.

I had to use the API to start a session, obtain a token, use the token to access the data and place in my report. I haven't done anything as sophisticated as writing a proper query yet or used parameters (except for the token itself) but it appears to work reliably.

I've hit a wall though with importing images - I can construct the URL to an image pretty easily but Jasper doesn't have the ability to enter HTTP headers when requesting the image, so I can't give it the token. Any ideas?!

Thanks!

I've finally been able to access images - I made a sort of proxy with PHP, that allowed me to pass the bearer token in the URL instead of the header. It's working great but isn't the tidyest of code, only works with JPEGs and doesn't manipulate the image in any way. Would love for someone to enhance it further.

My code/setup can be viewed here, hopefully it will help others.

Marked as solution because whilst it's still a lot of work to report with the API, I can at least use Jasper, PowerBI, Excel etc to embed images now and I don't believe there's a simpler option.