unable to get complete records via api

[ranjani25]

Hi All,

I did a recent integration from excel to tool rest api.After table conversion i could see [records] and

• as values in few columns.How can i get those values populated in excel.
  
  Also i need two dates in the end query dynamically.One is the system date and other is the 1st date of current month. This should be auto generated to the end url and data has to be automatically populated accordingly.Is this possible ?

 

[ashakantasharma]

You can get current date with =TODAY()
and for getting 1st Day of the current month you can use = =EOMONTH((Today(),-1)+1