For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
ame.hajimohammadi avatar image
1 ●0 ●0 ●2

SSIS issue EndOfDayPricing odata

HI


we added odata source in ssis package, for both option we faced error as below
1- we use webservice root as source:
"https://selectapi.datascope.refinitiv.com/RestApi/v1"

and for authentication we use basic, so test connection is success. but we we use this connection as source we face error as "unable to load" as below:

1681252374277.png

2-if we use extraction as source:
"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions"

and for authentication we use basic, so test connection is success. but we we use this connection as source

it can connect to collection and I used "RawExtractionResult",

to go to Column tab for setting: we face error as unable to load as below: "an error occurred while retriving the metadata"

1681253214944.pngif we click on preview this is the error: "The remote server returned an error: (400) Bad Request. (System)"


kindly help us urgently.


thanks

#SSIS #Extraction #EndOfDayPricing

#productextractionssis
1681252374277.png (20.7 KiB)
1681253214944.png (25.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @ame.hajimohammadi

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

4 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.8k ●250 ●52 ●74

@ame.hajimohammadi

Thanks for reaching out to us.

I am not familiar with the SSIS but according to the errors, that URL is unable to provide metadata.

The metadata URLs are available on this page: https://selectapi.datascope.refinitiv.com/RestApi/v1.

1681263008199.png

For example:

The /Extractions/RawExtractionResults endpoint is used to get a native/raw result from an extraction request, such as /Extractions/RawExtractionResults('<Job ID>')/$value.

For more information, please refer to the REST API Tutorials Introduction.

I hope that this information is of help.


1681263008199.png (55.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
ame.hajimohammadi avatar image
1 ●0 ●0 ●2

Hi @Jirapongse thanks for your reply

but to add as odata source, need to add Service Document then it will find Metadata outomatically in SSIS.

it seems something is wrong.


by the way now I have to use web service in Script task on SSIS, which is small version of C#.

when I want to add this web service as service Reference, I will face below error:

1681271445276.png
even in add service reference, in Advance when I select Extractions to add.
it will ask to save or open the json file. may I ask how can I add this webservice as reference in my script?

1681271912201.png


1681271445276.png (84.0 KiB)
1681271912201.png (74.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
ame.hajimohammadi avatar image
1 ●0 ●0 ●2

Hi @Jirapongse

I knew link of metadata and service documents, I wanted to add as web service in c#. but as I showed in picture, it get error and can not add it. also it will show download and save option.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
78.8k ●250 ●52 ●74

@ame.hajimohammadi

What connected service are you using?

I tested against OData Connected Services and it can load those service documents properly.

1681706754744.png


1681706797499.png


1681706754744.png (13.4 KiB)
1681706797499.png (40.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.