rest api post request date

Posted August 19, 2024Aug 19

Hello. The api documentation says that for creating a database record we can pass the date as datetime.

When I try to pass the date formatted like this 2024-08-18T19:19:06Z it does not seem to work and the record shows the current date.

Every other field, aspect of rest api works fine. Am I doing something wrong? Thanks.

bernhara
1

August 19, 2024Aug 19

That should be a valid format. 🤔

Maybe try only with the date to see if that works first?

2024-08-18

virap1
1

August 22, 2024Aug 22

Author

On 8/19/2024 at 8:08 AM, teraßyte said:
That should be a valid format. 🤔

Maybe try only with the date to see if that works first?
2024-08-18

Thank you. This would not be an ideal solution for me, but even this did not work.

Does anyone else have this issue? Any solutions.

3 weeks later...

September 6, 2024Sep 6

Could you share the full request that you're sending to the community, so that I can take a look at this?

September 7, 2024Sep 7

Author

Thank you @Daniel F. That part of the code looks like this:

			$date_tmp = new DateTime();
			$date_tmp->modify('-24 hours');			

			//$formattedDate = $date_tmp->format('Y-m-d\TH:i:s\Z');			
			$formattedDate = $date_tmp->format('Y-m-d');
	
			$data2 = array(
			"status" => "published",
			"category" => $cat_id,
			"author" => $author,
			"fields" => $fields2,
			"image" => $zzz_image,
			"date" => $formattedDate,
			"hidden" => 1, 
			);

		$curl2 = curl_init( $communityUrl . 'cms/records/7' );

You will notice there are 2 formattedDate variations, one is commented out. Neither one worked for me.

Edited September 7, 2024Sep 7 by virap1

2 months later...

November 13, 2024Nov 13

Author

Any updates on this? It has been 2 months.

1 month later...

January 4Jan 4

Author

@Daniel F can you please take a look into the code I posted? Thanks.

January 4Jan 4

it's setting the correct date (date is set to today -24h) but yeah, I have noticed that the record_publish_date column contains the current timestamp which is a bug.