Trying to migrate some data but cannot update 1-on-1

falko100

3 months ago

1 2

const pages = await payload.find({
  collection: 'pages',
});

pages.docs.forEach((page: Page) => {
  page.content.forEach((block) => {
    if (block.blockType === Slug.DefaultContent) {
      if (block.cta) {
        block.ctaList = [block.cta];

        payload.update({
          collection: 'pages',
          id: page.id,
          data: {
            content: page.content,
          },
        });
      }
    }
  });
});

• Selected Answer
  

  jmikrut

  Payload Team

  3 months ago

  Well, I think in this case @falko100 the problem is that your relationship field data is not in the right shape.

  Relationships have four potential different data shapes, so if you're trying to fill relationships, you need to determine which shape is right for your field(s) and pass data to the operation according to the required relationship field configuration.

  We have some docs about this here:
  https://payloadcms.com/docs/fields/relationship#how-the-data-is-saved

  We do this just about every day without problem, so I don't think this is a bug - moreso you are just passing data incorrectly. I'll bump this over to a Discussion and we can continue the conversation there!

  2 replies
• 

  falko100

  3 months ago

  Ahh ok, but the data returned isn't structured like:
  {"owner":"abcd-key"}
  but:
  {"id":"abcd-key", doc: {...}}

  Is there a way to use the Local API find to return plain data without the relations loaded?

• 

  falko100

  3 months ago

  After looking at the documentation a bit more, I figured I could add depth: 0, to my Local API call and then it works :)

  I currently made a route in my server.ts file. What's a good location to do these kind of data migrations?

• 

  denolfe

  Payload Team

  3 months ago

  Are there additional/required fields defined on your Pages collection? You will likely have to spread the existing page data like this:

  payload.update({
    collection: "pages",
    id: page.id,
    data: {
      ...page,
      content: page.content,
    },
  });

  Let me know if that helps.