Table of Contents

Search

  1. Preface
  2. Understanding Data Types and Field Properties
  3. Designing Processes
  4. Using and Displaying Data
  5. Designing Guides
  6. Designing Process Objects
  7. Designing Service Connectors
  8. Using Connectors
  9. System Services, Listeners and Connectors

2. Design

2. Design

Supported OData V4 and OData V2 URI Conventions

Supported OData V4 and OData V2 URI Conventions

You can use many OData V4 and OData V2 URI conventions to access data.

Supported OData Version 4 Conventions

You can use the following OData V4 URI conventions to access data:
  • Section 2. URL Components
  • Section 3 Service Root URL
  • Section 4.1 Addressing the Model for a Service
  • Section 4.3 Addressing Entities
    • You can use only Canonical URLs
  • Section 4.4 Addressing References between Entities
  • Section 4.6 Addressing a Property
  • Section 4.7 Addressing a Property Value
  • Section 5 Query Options
  • Section 5.1 System Query Options
  • Section 5.1.1 System Query Option $filter
  • Section 5.1.1.1 Logical Operators
  • Section 5.1.1.1.1 Equals
  • Section 5.1.1.1.2 Not Equals
  • Section 5.1.1.1.3 Greater Than
  • Section 5.1.1.1.4 Greater Than or Equal
  • Section 5.1.1.1.5 Less Than
  • Section 5.1.1.1.6 Less Than or Equal
  • Section 5.1.1.1.7 And
  • Section 5.1.1.1.8 Or
  • Section 5.1.1.4.1 contains
  • Section 5.1.1.4.2 endswith
  • Section 5.1.1.4.3 startswith
  • Section 5.1.1.6 Literals
  • Section 5.1.1.6.1 Primitive Literals
  • Section 5.1.3 System Query Option $select
  • Section 5.1.4 System Query Option $orderby
    • You can use $orderby only with a JDBC connector.
  • Section 5.1.5 System Query Options $top and $skip
    • You can use $skip only with a JDBC connector.
  • Section 5.1.6 System Query Option $count
  • Section 5.1.7 System Query Option $search.
    • You can do simple searches like http://host/service/Products?$search=blue
    • You cannot use $search and $filter at the same time
  • 5.1.8 System Query Option $format
See here for the complete OData V4 specification for URI conventions.

Supported OData Version 2 Conventions

Informatica recommends that you use OData V4. However, you can use the following OData V2 URI conventions to access data:
  • Section 1. URI Components
  • Section 2. Service Root URI
  • Section 3. Resource Path
  • Section 3.1. Addressing Entries
    • You cannot use relationships and complex entities
    Section 3.3. Addressing Service Operations
    Section 4. Query String Options
    Section 4.1. System Query Options
    Section 4.3. Top System Query Option ($top)
    Section 4.5. Filter System Query Option ($filter)
    • With the $filter option, you can use only 'endswith' and 'startswith'
    Section 4.7. Format System Query Option ($format)
    Section 4.8. Select System Query Option ($select)
    Section 4.9. Inlinecount System Query Option ($inlinecount)
See here for the complete list of OData V2 specification for URI conventions.


Updated February 11, 2021