Help

Whole Number turns into a decimal when pulled via API

Topic Labels: API
1486 5
cancel
Showing results for 
Search instead for 
Did you mean: 
meganghl
4 - Data Explorer
4 - Data Explorer

We have a Number field that we use for height that is always entered as a whole number in inches. Example: 65 or 66. Yet, when we pull this data via API, it will change it to a decimal. Example: 65 turns into 64.8 or 65.2. We do not understand why this would happen.

 

Any help is appreciated, thank you

5 Replies 5
Deep_Vyas
7 - App Architect
7 - App Architect

Check the source API is pulling up the height data... 

Airtable Expert | S: deepvyas71 | E: deepvyas71@gmail.com

It appears to be pulling the correct field, but 63.6 is not what is in the table.Untitled.jpg

Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Is the height actually input as whole numbers in the source, or is it just displayed as whole numbers in the source?

Ie. You can have an Excel/Google sheet holding the value 63.6, but it will appear as 64 based on the display settings on the cell. When exported somewhere else, the true value (63.6) is what gets passed along, not the displayed value.

Yes. The height is inputted as a whole number in the source.

Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

The source in this case is an Airtable table/base, correct?

If so, can you duplicate the base and remove any sensitive info, then share the cleaned up version here so that we can look at it?