PUT Rest API request for hasMany Relationship

[iasisalomon]

Model

...
	slug: 'tournaments',
	labels: {
		singular: 'Tournament',
		plural: 'Tournaments',
	},
	admin: {
		useAsTitle: 'tournament',
	},
	access: {
		read: () => true,
	},
	fields: [
		{
			name: 'standings',
			type: 'relationship',
			relationTo: 'standings',
			hasMany: true,
		},
...

When i try the following PUT request, the request succeeds to edit the information of the relations IDS

curl --location --request PUT 'http://localhost:8081/api/tournaments/62ccea3dc2ea654f4bcc28e9?locale=en&depth=0&fallback-locale=null' \
--header 'Accept: */*' \
--header 'Accept-Language: es-419,es;q=0.9,en;q=0.8,en-US;q=0.7' \
--header 'Connection: keep-alive' \
--header 'Cookie: payload-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6Imlhc2lzYWxvbW9uQGdtYWlsLmNvbSIsImlkIjoiNjJjY2VhM2NjMmVhNjU0ZjRiY2MyN2EzIiwiY29sbGVjdGlvbiI6InVzZXJzIiwiaWF0IjoxNjU3NTk2Nzg3LCJleHAiOjE2NTc2MDM5ODd9.xhcoKvpE4BEvN9h76g1gYc1W_1EduDDLmkOT06M1t4Y' \
--header 'Origin: http://localhost:8081' \
--header 'Referer: http://localhost:8081/admin/collections/tournaments/62ccea3dc2ea654f4bcc28e9' \
--header 'Sec-Fetch-Dest: empty' \
--header 'Sec-Fetch-Mode: cors' \
--header 'Sec-Fetch-Site: same-origin' \
--header 'Sec-GPC: 1' \
--header 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36' \
--form 'standings="[\"62cceb0c67574b7f818537c5\",\"62cceb0d67574b7f8185389e\",\"62cceb0d67574b7f8185391a\"]"'

it pops an internal server error 500.

ERROR (payload): CastError: Cast to ObjectId failed for value "["62cceb0c67574b7f818537c5","62cceb0d67574b7f8185389e","62cceb0d67574b7f8185391a"]" (type string) at path "_id" for model "standings"
    at model.Query.exec (D:\Coding\axiedao\newcrm\node_modules\mongoose\lib\query.js:4777:21)
    at model.Query.Query.then (D:\Coding\axiedao\newcrm\node_modules\mongoose\lib\query.js:4876:15)
    at processTicksAndRejections (internal/process/task_queues.js:95:5)

Do i need to PUT the whole object instead of only the ids?? is there a better way to do this?

[jmikrut]

Hey @iasisalomon — no, you don't need to PUT the entire object. Just the IDs.

It looks to me like your backend is expecting the standings field to accept only one ID, and it's trying to parse the value into an ID. But, you've got hasMany: true specified on your field, so that field should be properly expecting an array of IDs.

Did you recently add the hasMany: true to your standings field and maybe forget to restart your Node process?

[iasisalomon]

Tried resetting, no changes

[iasisalomon]

const Standings = {
	slug: 'standings',
	labels: {
		singular: 'Standing',
		plural: 'Standings',
	},
	admin: {
		useAsTitle: 'mixed',
		enableRichTextRelationship: true,
	},
	access: {
		read: () => true,
	},
	fields: [
		{
			name: 'mixed',
			type: 'text',
			admin: {},
			hooks: {
				beforeChange: [
					async ({ data }) => {
						const season = await payload.find({
							collection: 'seasons',
							where: {
								_id: {
									equals: data.season,
									limit: 1,
									depth: 0,
								},
							},
						});
						const player = await payload.find({
							collection: 'players',
							where: {
								_id: {
									equals: data.player,
									limit: 1,
									depth: 0,
								},
							},
						});
						const tournament = await payload.find({
							collection: 'tournaments',
							where: {
								_id: {
									equals: data.tournament,
									limit: 1,
									depth: 0,
								},
							},
						});
						return `${player.docs[0].nickname} - ${season.docs[0].seasonNumber} - ${tournament.docs[0].tournament}`;
					},
				],
			},
		},
		{
			name: 'tournament',
			type: 'relationship',
			relationTo: 'tournaments',
			hasMany: false,
		},

This is the standings side of it, the relation is one to many. Will try today restarting the process. Just leaving this here because maybe I am misundestanding the relationship field.

[iasisalomon]

		{
			name: 'tournament',
			type: 'relationship',
			relationTo: 'tournaments',
			hasMany: true,
		},
		```
		Still does not work

[DanRibbens]

We did make a change recently that might have to do with a cache problem. When starting Payload, webpack is using the node_modules/.cache/webpack directory to save off your build for watching. You could try to delete the directory to see if that makes a difference.

Other than that you should be able to follow the documentation to know how the different relationship options change the shape of the data:
https://payloadcms.com/docs/fields/relationship#how-the-data-is-saved

Let us know how it goes!

[iasisalomon]

Tried doing that, but no change. Check the curl in the following commentary.

[iasisalomon]

Only way I could make it work:

curl --location --request PUT 'http://localhost:8081/api/tournaments/62cf101390d13b141cae000f' \
--header 'Accept: */*' \
--header 'Accept-Language: es-419,es;q=0.9,en;q=0.8,en-US;q=0.7' \
--header 'Connection: keep-alive' \
--header 'Cookie: payload-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6Imlhc2lzYWxvbW9uQGdtYWlsLmNvbSIsImlkIjoiNjJjY2VhM2NjMmVhNjU0ZjRiY2MyN2EzIiwiY29sbGVjdGlvbiI6InVzZXJzIiwiaWF0IjoxNjU3NzM2Nzk1LCJleHAiOjE2NTc3NDM5OTV9.9F8URJrGoVAHSD6GlpnfLCtc6Ebk_Ub3KP6JHnbeOw8' \
--header 'Origin: http://localhost:8081' \
--header 'Referer: http://localhost:8081/admin/collections/tournaments/62cf101390d13b141cae000f' \
--header 'Sec-Fetch-Dest: empty' \
--header 'Sec-Fetch-Mode: cors' \
--header 'Sec-Fetch-Site: same-origin' \
--header 'Sec-GPC: 1' \
--header 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36' \
--form '_payload="{\"standings\":[\"62cf10f379b4b7eb95e5584b\",\"62cf10f479b4b7eb95e55905\",\"62cf10f279b4b7eb95e556f6\"]}"'