Exam PL-400 topic 6 question 24 discussion

Actual exam question from Microsoft's PL-400

Question #: 24
Topic #: 6

DRAG DROP -
You are creating a Web API.
The API must be able to perform the following actions:
✑ Create a column in a Microsoft Dataverse table.
Update a column for an existing row.

Which HTTP methods should you use? To answer, drag the appropriate HTTP methods to the correct requirements. Each HTTP method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

Box 1: POST -

Create table definitions -
To create a table definition, POST the JSON representation of the entity definition data to the EntityDefinitions entity set path. The entity must include the definition for the primary name attribute. You don't need to set values for all the properties. The items on this list except for Description are required, although setting a description is a recommended best practice.

Box 2: PATCH -

Basic update -
Update operations use the HTTP PATCH verb. Pass a JSON object containing the properties you want to update to the URI that represents the record.
Reference:
https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-entity-definitions-using-web-api https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api

by Violoncello at Sept. 2, 2022, 11:52 p.m.

Comments

Submit Cancel

Violoncello

Highly Voted 1 year, 9 months ago

True, but this is general web page development question. POST is used to create a new entry in the database. PATCH is used for update, and GET is used for reading (selecting) from a database.

upvoted 5 times

MarioM

1 year, 9 months ago

Patch can be used for create column too. Upsert in other words.

upvoted 1 times

...

Juan0414

Most Recent 3 months, 3 weeks ago

- Create column -> POST (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-column-definitions-using-web-api#create-columns) - Update a column for an existing row -> PATCH (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api#basic-update) FYI: If it were update a column then the HTTP method would be PUT (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api#basic-update) "As mentioned in Update table definitions, data model entities are updated using the HTTP PUT method with the entire JSON definition of the current item. This pattern applies to entity attributes and entities."

upvoted 1 times

...

ziggy1117

10 months, 4 weeks ago

answer is correct

upvoted 2 times

...