The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'

(0) Share

Report

Posted on by matthewchubb

Hi there,

I'm trying to build an HTML table from the payload of an HTTP request.

The payload contains today's bookings/arrivals, ultimately I would like to email myself each day with a table showing displaying the following information for each arrival.

apartment
channel
guest-name
phone
adults
children
check-in
check-out
assistant-notice
price

This is the error I get; The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'

Any help is much appreciated.

This is the payload

{
 "type": "object",
 "properties": {
 "statusCode": {
 "type": "integer"
 },
 "headers": {
 "type": "object",
 "properties": {
 "x-ratelimit-remaining": {
 "type": "string"
 },
 "x-ratelimit-limit": {
 "type": "string"
 },
 "x-ratelimit-retry-after": {
 "type": "string"
 },
 "pragma": {
 "type": "string"
 },
 "x-frame-options": {
 "type": "string"
 },
 "vary": {
 "type": "string"
 },
 "access-control-allow-origin": {
 "type": "string"
 },
 "x-content-type-options": {
 "type": "string"
 },
 "strict-transport-security": {
 "type": "string"
 },
 "Cache-Control": {
 "type": "string"
 },
 "Date": {
 "type": "string"
 },
 "Server": {
 "type": "string"
 },
 "Content-Type": {
 "type": "string"
 },
 "Expires": {
 "type": "string"
 },
 "Content-Length": {
 "type": "string"
 }
 }
 },
 "body": {
 "type": "object",
 "properties": {
 "page_count": {
 "type": "integer"
 },
 "page_size": {
 "type": "integer"
 },
 "total_items": {
 "type": "integer"
 },
 "page": {
 "type": "integer"
 },
 "bookings": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "id": {
 "type": "integer"
 },
 "reference-id": {
 "type": "string"
 },
 "type": {
 "type": "string"
 },
 "arrival": {
 "type": "string"
 },
 "departure": {
 "type": "string"
 },
 "created-at": {
 "type": "string"
 },
 "modifiedAt": {
 "type": "string"
 },
 "apartment": {
 "type": "object",
 "properties": {
 "id": {
 "type": "integer"
 },
 "name": {
 "type": "string"
 }
 }
 },
 "channel": {
 "type": "object",
 "properties": {
 "id": {
 "type": "integer"
 },
 "name": {
 "type": "string"
 }
 }
 },
 "guest-name": {
 "type": "string"
 },
 "firstname": {
 "type": "string"
 },
 "lastname": {
 "type": "string"
 },
 "email": {},
 "phone": {
 "type": "string"
 },
 "adults": {
 "type": "integer"
 },
 "children": {
 "type": "integer"
 },
 "check-in": {
 "type": "string"
 },
 "check-out": {
 "type": "string"
 },
 "notice": {
 "type": "string"
 },
 "assistant-notice": {
 "type": "string"
 },
 "price": {
 "type": "integer"
 },
 "price-paid": {
 "type": "string"
 },
 "commission-included": {
 "type": "number"
 },
 "prepayment": {},
 "prepayment-paid": {
 "type": "string"
 },
 "deposit": {},
 "deposit-paid": {
 "type": "string"
 },
 "language": {
 "type": "string"
 },
 "guest-app-url": {
 "type": "string"
 },
 "is-blocked-booking": {
 "type": "boolean"
 },
 "guestId": {
 "type": "integer"
 },
 "related": {
 "type": "array"
 }
 },
 "required": [
 "id",
 "reference-id",
 "type",
 "arrival",
 "departure",
 "created-at",
 "modifiedAt",
 "apartment",
 "channel",
 "guest-name",
 "firstname",
 "lastname",
 "email",
 "phone",
 "adults",
 "children",
 "check-in",
 "check-out",
 "notice",
 "assistant-notice",
 "price",
 "price-paid",
 "commission-included",
 "prepayment",
 "prepayment-paid",
 "deposit",
 "deposit-paid",
 "language",
 "guest-app-url",
 "is-blocked-booking",
 "guestId",
 "related"
 ]
 }
 }
 }
 }
 }
}

Categories:

Building flows

All responses (12)

Answers (1)

Sort by

SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Instead of assigning Parse JSON Body to Create HTML table, assign it bookings dynamic content: body('Parse_JSON')?['body']?['bookings']
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
matthewchubb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi SamLed,

Thanks for the speedy response. I have now updated it as follows but am still getting this error.
SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Ok,
Ok I based my previous expression to the schema you provided in your first post, but data result saw in your last post tells me it is not the right one, generate Parse JSON schema with HTTP request outputs:

then select "bookings" dynamic content:

It should give :
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
matthewchubb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I used the raw output from the HTTP request and generated the schema with that.

The output options I get for the HTTP request are shown here, I don't have 'output' only Body, Headers and Status code so it looks like this;
SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, just try to use body('Parse_JSON')?['bookings'] as expression in your Create HTML table from field then.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
matthewchubb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help, that is now producing an output.

It's now producing 4 tables, one for each property which is fine (probably better) but, each table shows the booking 4 times, any idea why?

I didn't ask it to do an apply to each but when i changed the table to custom it added it.

This is the output that is sent by email.
SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Well, PA do badly add a for each because of array. Don't use proposed dynamic contents. Replace this apply to each with a new create HTML table and manually add the dynamics content by giving them in expression tab:

From: body('Parse_JSON')?['bookings']
Value : item()['property name']

Do it for every value you want in your table.

[edit] replace bad formatted expression. Sorry.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
matthewchubb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, what's the expression I should be entering into the new HTML table's From field?
Verified answer

SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

okay, sorry I messed up my expression in my previous post (edited it). Remove the apply to each and create a new Create HTML table. Still don't use dynamic contents proposed, it will create an Apply to each again but enter your expressions manually:

From: body('Parse_JSON')?['bookings']
Column: custom

Header Value
Property item()['apartment']
Name item()['guest-name']
... ...
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
matthewchubb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the delay in responding, I've been away.

That works perfectly thank you!

How would l reference the 2nd item? For example, 'apartment' returns the 'id' of the apartment and the 'name', I would just like the 'name'. The same with 'channel', I need the name and not the 'id'

I tried this but just get errors

Thank you.