Skip to Content
0

Clarification required for Odata Adapter

Dec 21, 2016 at 12:36 PM

224

avatar image

Dear All.

requesting you to please clarify my doubts which is mentioned below.

Scenario: Odata to SOAP.

i do have two entity selection (invoices and InvoiceItemDetail) which is exposed separatly from Odata service.

requirement is: need to take invoice and invoiceitemdetail together and the same to be sent to target system and message mapping also to be done because of target schema is different.

the requirement is done as mentioned below.

now, the Odata service team come up with idea were we can achieve this using $expand and $filter command. so that tried with url https://addrna.ondemand.com/ser/test.svc/Invoices?$filter=InvoiceNo eq 'I04' in browser which is giving invoice number I04 details, but i f use the same url in receiver odata adapter's address filed it's throwing an error in HCI like" LastError = com.sap.gateway.core.ip.component.odata.exception.OsciException: Bad Request : 400 : HTTP/1.1 http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> xml:lang="en">Invalid filter expression: 'InvoiceNo eq 'I04'/$metadata'. , cause: com.sap.gateway.core.ip.component.odata.exception.OsciException: Bad Request : 400 : HTTP/1.1 http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> xml:lang="en">Invalid filter expression: 'InvoiceNo eq 'I04'/$metadata'. "

and my clarification are

1. Do Address parameter which is available in receiver adapter support the above kind of URLs.

2. how can i get from records from invoice and invoiceitemdetails by using single receiver adapter which is recommended.

3. do module operator support multiple entity set.

4. and how to get my xsd if i can get the records from invoice and invoiceitemdetails by using single receiver adapter.

please do needful

Regards

Ramesh

e1.png (26.4 kB)
e2.png (48.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers