question

Tobz avatar image
0 Votes"
Tobz asked DavidAMoss-8370 commented

Getting data from UltiPro Reports as a service using SSIS

Hi everyone,

Anyone tried pulling data from ultipro reports as a service (WSHttpBinding_IBIDataService) using SSIS.

Please I need assistance on how to create the reference used in the script component.

Thanks

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have not. One possibility is to created a console application that imports the report data into a SQL table. Then call the console application from SSIS. The following link has sample code for creating the console application. Just so you know, I'm still in the process of trying to get the console application to work

https://connect.ultipro.com/documentation#/api/1195

0 Votes 0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi @Tobz ,

This tutorial shows how to call a web API from a .NET application, using System.Net.Http.HttpClient.

static async Task RunAsync()
{
// Update port # in the following line.
client.BaseAddress = new Uri("http://localhost:64195/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
...

Please refer to Call a Web API From a .NET Client (C#).

Best Regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Tobz ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·