Using $expand option in ADF RRS feed

  • Question

  • Hi,

    I have two tables called acs_Inspections and CS_Controls. I need to select two columns from acs_Inspections and one column in CS_Controls. The following is the GET URL i'm using on POSTMAN and SOAP UI and URL works just fine but on ADF it only returns CS_InspectionId,CS_LastModififiedOn and the CS_ControlId from CS_Controls is not returned. Just not sure if it could be some limitations on ADF.

    GET URL: https://www59.enablon.com/anglov8-uat/odata/v4/acs_Inspections?$select=CS_InspectionId,CS_LastModififiedOn&$expand=CS_Controls($select=CS_ControlId)

    Please kindly advise why im not able to pull the expanded part on my URL. See the below results from POSTMAN.



    Thursday, November 15, 2018 11:45 AM

All replies

  • Hi, what type of connector did you use to send API call? Web table connector or HTTP? Would you please share the pipeline and activity runId with us to debug?
    Thursday, November 15, 2018 1:31 PM