Error "Additional fields/columns not allowed in inputs of type record and table" while using Type

(0) Share

Report

Posted on by Taeke

UDF and UDT sound great. While experimenting with them I experienced the following:

In app.formulas I define the following types

/*
{
    "qotd_date": 2025-02-12T11:26:08.485Z,
    "quote": {
            "id": 38374,
            "dialogue": false,
            "private": false,
            "tags": [
                "love"
            ],
            "url": "https://favqs.com/quotes/aristotle/38374-love-is-compo-",
            "favorites_count": 2,
            "upvotes_count": 1,
            "downvotes_count": 0,
            "author": "Aristotle",
            "author_permalink": "aristotle",
            "body": "Love is composed of a single soul inhabiting two bodies."
    }
}
*/
tags := Type([Text]);
quotev2 := Type(
    {
        id: Number,
        dialog: Boolean,
        private: Boolean, 
        tags: tags,
        url: Text,
        favorites_count: Number, 
        upvotes_count: Number, 
        downvotes_count: Number, 
        author: Text, 
        author_permalink: Text, 
        body: Text
    }
);
payload := Type(
    {
        qotd_date: DateTime, 
        quote: quotev2
    }
);
quotesv2 := Type([payload]);

addQuotev2( collection: quotesv2) : quotesv2 = {    
    Collect(
        collection,
        ParseJSON(qotd.Run(2).payload, payload)
    )
};

Then I initialize a collection compatibel with Type quotev2

ClearCollect(
    myQuotesV2, 
    {
        qotd_date: Blank(), 
        quote: {
            id: Blank(),
            dialog: Blank(),
            private: Blank(),
            tags: [Blank(),Blank()],
            url: Blank(),
		    favorites_count: 0,
		    upvotes_count: 0,
		    downvotes_count: 0,
		    author: Blank(),
		    author_permalink: Blank(),
            body: Blank()
        }
    }
); 
Clear(myQuotesV2);

I create a gallery with the Items property set to myQuotesV2 and create a button to add q new quote to the gallery with this OnSelect

IfError( 
    addQuotev2(myQuotesV2), 
    UpdateContext(
        {
            _error: FirstError.Message
        }
    )
)

Pushing the button results in aan error

Additional fields/columns not allowed in inputs of type record and table

Categories:

Experimental features

I have the same question (0)

All responses (4)

Answers (0)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Can you confirm and post screenshots of the schema returned from the ParseJSON - is it identical to the Type you defined:

id: Number, dialog: Boolean, private: Boolean, tags: tags, url: Text, favorites_count: Number, upvotes_count: Number, downvotes_count: Number, author: Text, author_permalink: Text, body: Text

Was this reply helpful? Yes No
Taeke 12 on at

Like (0)

Report
@iAm_ManCat,

I am not sure whether I understand your question. The response I get is this:

{ "duration": 1388.4, "size": 436, "status": 200, "headers": { "Cache-Control": "no-cache", "content-encoding": "gzip", "Content-Type": "application/json; charset=utf-8", "Date": "Wed, 12 Feb 2025 20:43:00 GMT", "expires": -1, "pragma": "no-cache", "strict-transport-security": "max-age=31536000; includeSubDomains", "timing-allow-origin": "*", "vary": "Accept-Encoding", "x-ms-apihub-cached-response": true, "x-ms-apihub-obo": false, "x-ms-client-tracking-id": "08584622139048616639450713375CU18", "x-ms-correlation-id": "c3a8d62a-6e6d-4821-8fae-d4e3f52190f8", "x-ms-dlp-gu": "-|-", "x-ms-dlp-re": "-|-", "x-ms-environment-id": "default-8e8aa81e-17bc-49e2-b4cf-f181433ad94a", "x-ms-error-type": "UnknownError", "x-ms-execution-location": "westeurope", "x-ms-ratelimit-burst-remaining-workflow-writes": 856, "x-ms-ratelimit-remaining-workflow-download-contentsize": 61355596, "x-ms-ratelimit-remaining-workflow-upload-contentsize": 61356020, "x-ms-ratelimit-time-remaining-directapirequests": 2856561, "x-ms-request-id": "westeurope:c3a8d62a-6e6d-4821-8fae-d4e3f52190f8", "x-ms-tenant-id": "8e8aa81e-17bc-49e2-b4cf-f181433ad94a", "x-ms-tracking-id": "c3a8d62a-6e6d-4821-8fae-d4e3f52190f8", "x-ms-trigger-history-name": "08584622139048616639450713375CU18", "x-ms-workflow-id": "b358c6aaf16843a99aa63e5d00187460", "x-ms-workflow-name": "13c875da-b971-4758-a702-43a216bba10f", "x-ms-workflow-run-id": "08584622139048616639450713375CU18", "x-ms-workflow-system-id": "/locations/westeurope/scaleunits/prod-87/workflows/b358c6aaf16843a99aa63e5d00187460", "x-ms-workflow-version": "08584629211713630256" }, "body": { "payload": { "qotd_date": "2025-02-13T00:00:00.000+00:00", "quote": { "id": 62049, "dialogue": false, "private": false, "tags": [], "url": "https://favqs.com/quotes/abdu-l-baha/62049-to-be-pure-an-", "favorites_count": 2, "upvotes_count": 0, "downvotes_count": 0, "author": "Abdu'l-Baha", "author_permalink": "abdu-l-baha", "body": "To be pure and holy in all things is a necessary characteristic of the unenslaved mind." } } }, "responseType": "json" }

Which is - as far as I can see - compatible with the payload type I declared.

Then the ParseJSON gives this result:

{ "status": null, "duration": null, "dataSource": null, "responseSize": null, "controlName": "App", "propertyName": "Formulas", "nodeId": 52, "formulaData": { "script": "", "spanStart": 1464, "spanEnd": 1503 }, "data": { "errorMessage": "Additional fields/columns not allowed in inputs of type record and table", "raiseToastNotification": false, "wasReported": false, "functionName": "ParseJSON", "context": { "entityName": "App", "propertyName": "Formulas", "id": 193, "nodeId": 52, "diagnosticContext": { "span": { "start": 1464, "end": 1503 } } }, "info": "Additional fields/columns not allowed in inputs of type record and table" } }

Does this answer your question?

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Can you check or show what the structure of the returned payload is, as I think that's likely the issue with extra columns or values being retrieved from the flow run:

qotd.Run(2).payload

Was this reply helpful? Yes No
Taeke 12 on at

Like (0)

Report
Hello @iAm_ManCat,

In my previous post I listed the payload structure:

"body": { "payload": { "qotd_date": "2025-02-13T00:00:00.000+00:00", "quote": { "id": 62049, "dialogue": false, "private": false, "tags": [], "url": "https://favqs.com/quotes/abdu-l-baha/62049-to-be-pure-an-", "favorites_count": 2, "upvotes_count": 0, "downvotes_count": 0, "author": "Abdu'l-Baha", "author_permalink": "abdu-l-baha", "body": "To be pure and holy in all things is a necessary characteristic of the unenslaved mind." } } }

In the original code I posted I assume I collect this payload structure from the body and try to parse it as a payload type.

ParseJSON(qotd.Run(2).payload, payload)

Or do I misunderstand your question?

Was this reply helpful? Yes No