Publicly available Northwind OData service not displaying Expand option

Created a new OData Integration data resource using the publicly available Northwind OData service. But I am not able to see the expand option for the entity sets.
Am I missing something ?

1 Like

Hi,

I am not sure what expand option you are referring to. Could you provide more context, please? Perhaps a screenshot would suffice.

Sure… Based on the SAP Learning Journey certification course - we can add an OData data resource and then be able to select the expand entities…
https://learning.sap.com/learning-journey/utilize-low-code-no-code-applications-and-automations-for-citizen-developers

This works when I use the SAP Sales Cloud OData Service… That’s what the certification course uses. However, when I use other OData Services, it doesn’t work. See image below.
https://my346234.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi

Hi,

Not all OData services have the expanded entities configured. As you can see from the screenshot, the Northwind OData does not have any expandable entities, thus you are not seeing any in the Composer.

The Service Cloud from the Learning Journey has expanded entities, hence you are seeing them in the OData configuration.

1 Like

Interesting… I have never seen this OData URL syntax ($expand clause on $metadata). Is this part of the OData specs ?

Typically, the $expand clause is used along with an entity.

https://services.odata.org/v2/Northwind/Northwind.svc/Products?$expand=Supplier&$format=json
https://services.odata.org/v2/Northwind/Northwind.svc/Orders?$expand=Order_Details&$format=json

Hi,

Composer automatically expands entities in the OData request.
After running a ‚Äėlist‚Äô test on the ‚ÄúProducts‚ÄĚ entity, you can see all the data available.

But that’s not going to add the Supplier entity to the schema definition… Ideally, I would like SAP AppGyver to make the $expand call to Supplier (along with Products) and create the schema definition for me.

That’s what it does with the SAP Sales Cloud OData service… But not with other OData Services.

We need to get the Supplier data along with Products data to create the schema… Something like this.

That data is included in the main request. You can isolate it and use it via a formula.