1 Reply Latest reply on Sep 11, 2020 2:08 PM by Sai Narasimha Prasad Rebba

    REST API CALL

    Shashank Raj New Member

      I have a REST API call which fetches price for a given query condition

      .

      http://localhost:1512/rest/V1.0/list/Article/ArticlePriceSales/bySearch?catalog=MASTER&query=((Article.ManufacturerAID startsWith "7142309" ) and (Article.Res_Text100_02 equals "001") )&fields=ArticlePriceSales.PriceType,ArticlePriceValueSales.Amount(1)

       

      I want certain fields at header level and in different entity to be returned along with other fields but when passing that in the query

       

      http://localhost:1512/rest/V1.0/list/Article/ArticlePriceSales/bySearch?catalog=MASTER&query=((Article.ManufacturerAID startsWith "7142309" ) and (Article.Res_Text100_02 equals "001") )&fields=Article.ManufacturerAID,ArticlePriceSales.PriceType,ArticlePriceValueSales.Amount(1)

       

      I get following error: Fields: The field 'Article.ManufacturerAID' does not have the entity 'ArticlePriceSales' as parent.

       

       

      How can I modify the query to get the required details.

        • 1. Re: REST API CALL
          Sai Narasimha Prasad Rebba Guru

          Hi Shashank,

           

          It is not possible to get the fields from different entity in the rest api call. It works for sub-entity fields.

           

          The below KB article on Getting the items having Media assets through Rest API query and used sub-entity and few other transition fields from different entity "MediaAsset". I think this may possible with transition fields.

           

          ArticleMediaAssetMap.MediaAsset->MediaAssetDocumentAttributes.WidthHMM(en, originalimage),

          ArticleMediaAssetMap.MediaAsset->MediaAssetDocumentAttributes.LastModifiedHMM(en, originalimage)

           

          https://kb.informatica.com/howto/6/Pages/23/618084.aspx

           

          Thank you
          Sai Prasad