# Column names in Web API DS

**URL:** <https://community.squaredup.com/t/column-names-in-web-api-ds/2037>\
**Category:** SquaredUp Cloud\
**Created:** [June 28, 2023, 1:34pm UTC](https://community.squaredup.com/t/column-names-in-web-api-ds/2037 "2023-06-28T13:34:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nickde9999](https://community.squaredup.com/letter_avatar_proxy/v4/letter/n/f6c823/32.png) [@nickde9999](https://community.squaredup.com/u/nickde9999)\
**Post date:** [June 28, 2023, 1:34pm UTC](https://community.squaredup.com/t/column-names-in-web-api-ds/2037/1 "2023-06-28T13:34:43Z")

</div>

Hi

I have this SQL analytics query configured:

SELECT Activities.name AS Name, TimeEntries.duration.startedAt, TimeEntries.duration.stoppedAt, TimeEntries.activityId  
FROM TimeEntries  
INNER JOIN Activities ON TimeEntries.activityId=Activities.id

Problem is that I do not get the duration.startedAt and duration.stoppedAt column.

If i call them with TimeEntries.\* they are visible:  
 ![image](https://community-cdn.squaredup.com/original/2X/a/a2c715d3f2daaa630e48f2f2202ca7faca1a30e5.png)

How do I include only the column names with dots in them ?

KR  
Nick

---

<div class="post-metadata">

**Author:** ![andy.mcmullan](https://community.squaredup.com/letter_avatar_proxy/v4/letter/a/9dc877/32.png) [@andy.mcmullan](https://community.squaredup.com/u/andy.mcmullan)\
**Post date:** [June 28, 2023, 2:30pm UTC](https://community.squaredup.com/t/column-names-in-web-api-ds/2037/2 "2023-06-28T14:30:24Z")

</div>

Hi Nick, try adding square brackets, e.g. TimeEntries.[duration.startedAt] instead of TimeEntries.duration.startedAt.

Andy
