OData with EXPAND query option works from browser but not from code

(0) Share

Report

Posted on by Anderson Joyle

Hi all,

I'm trying to run the following OData query:

">client123.cloudax.dynamics.com/.../ProductsV2('abcdefgh')

What's happening is when I run this URL from a browser, I get the ReleasedProducts in line with retrieved resources. When I run this from my Python test code, I get ProductsV2 records with no problem but no in line records from ReleasedProducts.

These are the headers I'm send along with my GET request:

'Authorization': 'Bearer xxxXXX...'

'Accept': 'application/json'

'Content-Type': 'application/json; charset=utf-8'

'OData-MaxVersion': '4.0'

'OData-Version': '4.0'

My cloud-hosted dev environment is running Update35 (7.0.5644.35548) version.

Any advice will be much appreciated.

I have the same question (0)

All responses (8)

Answers (1)

Deekshit Addepalli on at

Like (0)

Report

Can you show a screenshot of what you see via the browser vs what your python code returns? Is it for the same ProductNumber?

Was this reply helpful? Yes No
Anderson Joyle 25 on at

Like (0)

Report

There you go.

Lighter pic is what I get requesting OData from Firefox. Darker pic is the result from the terminal. eTag value is the same for both results.

Just a bit more details on this, I also analyzed headers that firefox is using to compose GET request:

I tried to use the same headers from my python code (except cookie). The results were the same.

Thanks for your time.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Anderson,

Could you try to narrow both queries (from browser and from your code) using the same product number?

Was this reply helpful? Yes No
Anderson Joyle 25 on at

Like (0)

Report

Hi Gunjan,

Thanks for taking time to responde.

I already using same product number. In fact, looking closely to my previous response (the one with some screenshots) you can tell that I'm retrieving the same records on both queries based on eTag value.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Anders,

Have you tested with any other third party tools? There are some details here -

docs.microsoft.com/.../third-party-service-test

Was this reply helpful? Yes No
Anderson Joyle 25 on at

Like (0)

Report

Yes. I tested with Postman as well. The results are the same as my Python code. I get ProductsV2, but not in line ReleasedProduct record.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

What is your default company ? May be the company you are querying does not have any data ?

Was this reply helpful? Yes No
Suggested answer

Anderson Joyle 25 on at

Like (1)

Report

Spot on! I checked to which user id my Azure Application was assigned to and happens it was set to DAT company. At the end I was using two different users to run the same query.

Thanh you all for taking your time.

Was this reply helpful? Yes No