Mark

1. Community
2. CORE APIs
3. API Question: How does Invoice connect to Client or Project?

Evan I believe you are using our Power BI connector Simply pass "InvoiceDetails" to Expand Option when loading data as shown in the screenshot below. Click on Transform Data to open the transform w...

• View comment
• Created August 19, 2020 01:48
• 0 votes

1. Community
2. CORE APIs
3. Token Grant failure - invalid grant

The company id is not returned in the query string. To get the company id after you are logged in please use the userinfo endpoint as documented here to get the company Id, you will use the bearer ...

• View comment
• Created July 03, 2020 22:17
• 0 votes

1. Community
2. CORE APIs
3. Securely load Core data in realtime and display for all users

Users need to be authorized. After the user has been authorized you can save the access token, expiration (by default access token is valid for an hour) and Refresh token locally in your database o...

• View comment
• Edited March 06, 2020 21:53
• 0 votes

1. Community
2. CORE APIs
3. Getting Project Budget Information

I have already answered your question in a separate thread, here is the link for your reference https://corehelpcenter.bqe.com/hc/en-us/community/posts/360039512433-Construct-where-clause-in-header...

• View comment
• Edited March 05, 2020 22:17
• 0 votes

1. Community
2. CORE APIs
3. Support for Reports

Core API are not supposed to give access to the reports, however you can use various end points to extract information that for the most part will allow you to calculate the values on the reports o...

• View comment
• Created March 05, 2020 18:35
• 0 votes

1. Community
2. CORE APIs
3. Construct where clause in header to check if field contains substring

I am wondering why you are building a dashboard outside Core. We already have project dashboard widgets for Work in Progress and Work in Hand within Core.

• View comment
• Edited March 05, 2020 22:23
• 0 votes

1. Community
2. CORE APIs
3. Construct where clause in header to check if field contains substring

Joseph,   The ProjectIds/PhaseIds are stored in a collection InvoiceDetails for a certain invoice , this is a collection on the invoice object. With core you can have multiple project phases  bille...

• View comment
• Edited March 06, 2020 21:49
• 0 votes

1. Community
2. CORE APIs
3. Construct where clause in header to check if field contains substring

What information are you looking for that is not in the project Model?

• View comment
• Edited March 04, 2020 19:19
• 0 votes

1. Community
2. CORE APIs
3. Construct where clause in header to check if field contains substring

Yes. It will be a good idea to store UUID locally. Also to make the pull faster look into using Fields. This will allow you to limit your response to only the fields that you need for smaller paylo...

• View comment
• Edited March 05, 2020 22:20
• 0 votes

1. Community
2. CORE APIs
3. Construct where clause in header to check if field contains substring

Joseph Core public apis give you the ability to filter out records using combination of "where" clause and operators like IN, BETWEEN etc. At this time we do not have the contains or like operator....

• View comment
• Edited March 05, 2020 22:18
• 1 vote