AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica OData wit...
OData connection wo...
 
Notifications
Clear all

OData connection works, but data is empty! Returns Column Headers only.  

    Last Post
RSS

Sweed
Posts: 2
 Sweed
February 19, 2021 2:22 pm
(@sweed)
2-5 Posts
Joined: 3 weeks ago

Hi everyone! I've been pulling in data from some General inquires that my company has in Acumatica, successfully, into Power BI.

However, the one report I really need I cannot get to work.  I am able to connect to the feed, but it downloads just 114k of data, produces a table with correct column headers but all cell data is empty.  

XML feed connect and returns, but empty as well. 

Does anyone have any ideas?  I'm on about hour 20 trying to get this work.  Running out of ideas :/ 

I've attached some screenshots of my GI and what return in Power BI.  

Thank you so much!

Screenshot 2021 02 19 111618
Screenshot 2021 02 19 112146
Screenshot 2021 02 19 112118
Screenshot 2021 02 19 112137
Screenshot 2021 02 19 112114
Screenshot 2021 02 19 112131
Screenshot 2021 02 19 112122
Screenshot 2021 02 19 112108
Screenshot 2021 02 19 112141
Screenshot 2021 02 19 112100

 

3 Replies
Royce Lithgo
Posts: 449
 Royce Lithgo
February 21, 2021 7:29 pm
(@roycelithgo)
Over 200 Posts
Joined: 11 months ago

You can't use Parameters with OData: https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiries-parameters-and-odata/

You need to design the Query to not rely on Parameters. Your current conditions will return no data if the parameters are Null, which they will be in OData (you haven't tested for Empty[DateFrom] and [DateTo].

Reply
Sweed
Posts: 2
 Sweed
February 22, 2021 6:33 pm
(@sweed)
2-5 Posts
Joined: 3 weeks ago

Hey Royce, you are a godsend.  Thank you!  As soon as I removed these the floodgates were opened.  All systems go!

Reply
Royce Lithgo
Posts: 449
 Royce Lithgo
February 22, 2021 6:53 pm
(@roycelithgo)
Over 200 Posts
Joined: 11 months ago

No worries at all. Glad to have helped out. 

Reply
Sweed liked
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,723 Topics
7,913 Posts
6 Online
1,169 Members

Latest Post: AUGForums.com Live Suggestions Our newest member: ibvbghujhu05 Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×