How to show the names fetched from integration object in new row?

jignesht0001

Certified Senior Developer

over 2 years ago

Hello All I am new into Appian I am fetching data from integration object where i get all nearby vaccination centers name, type of vaccine, available slot and it is free or paid. But when I fecth the details i get all the details in one row only. So how can i show center name row wise please help me I am new into appian and facing problem in these

See Here I am getting center name in one row only. How to show in different row. I am sharing the code also please tell me where and what should i do the changes

a!localVariables(
local!result: rule!CVMS_vaccinationCenter_INT(district_id: ri!district_id,date: ri!date),

a!formLayout(
label: "Form",
contents: {
a!textField(
label: "Enter Your District Id",
labelPosition: "ABOVE",
value: ri!district_id,
saveInto: ri!district_id,
refreshAfter: "UNFOCUS",
required: true,
validations: {}
),
a!textField(
label: "Enter The Date for which want to check availability",
labelPosition: "ABOVE",
placeholder: "DD-MM-YYYY",
value: ri!date,
saveInto: ri!date,
refreshAfter: "UNFOCUS",
required: true,
validations: {}
),
a!gridField(
label: "Read-only Grid",
labelPosition: "ABOVE",
data: local!result.result.body,
columns: {
a!gridColumn(
label: "Center Name",
value: fv!row.sessions.name

),
a!gridColumn(
label: "Grid Column",
value: null
)
},
pageSize: null,
pagingSaveInto: local!result,
validations: {}
)
},
buttons: a!buttonLayout(
primaryButtons: {
a!buttonWidget(
label: "Submit",
submit: true,
style: "PRIMARY",
loadingIndicator: true
)
},
secondaryButtons: {
a!buttonWidget(
label: "Cancel",
value: true,
saveInto: {},
submit: true,
style: "NORMAL",
validate: false
)
}
)
))

Discussion posts and replies are publicly visible

Top Replies

Naresh over 2 years ago in reply to jignesht0001 +1
Certified Lead Developer

Sure will try to help you, If possible can you provide integration results that you are getting ( local!result). It help us to understand how your data is structured.
GopalK over 2 years ago in reply to jignesht0001 +1 verified
Certified Lead Developer

Hi, Try configuring your grid like below configuration. a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: local!result.result.body.sessions, columns: { a!gridColumn( label: "Center…
GopalK over 2 years ago in reply to jignesht0001 +1
Certified Lead Developer

Hi jignesht0001 , You were not indexing correctly from the result which you got from integration. You need to understand how grid works and data iterates through rows. I assume you are new to Appian. Its…

Parents

0 Naresh
Certified Lead Developer
over 2 years ago

Hi

Are you able to provide the result of your integration.

local!result.result
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Naresh
Certified Lead Developer
over 2 years ago

Hi

Are you able to provide the result of your integration.

local!result.result
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 jignesht0001
Certified Senior Developer
over 2 years ago in reply to Naresh

Yes the result of integration object I am able to fetch in interface but i am getting all name in one row only. I want in different row please help me
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Naresh
Certified Lead Developer
over 2 years ago in reply to jignesht0001

Sure will try to help you, If possible can you provide integration results that you are getting (local!result). It help us to understand how your data is structured.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jignesht0001
Certified Senior Developer
over 2 years ago in reply to Naresh
Value

Dictionary

successtrue(Boolean)

resultHttpResponse

statusLine"HTTP/1.1 200 OK"(Text)

statusCode200(Number (Integer))

headersDictionary

Content-Type"application/json; charset=utf-8"(Text)

Transfer-Encoding"chunked"(Text)

Connection"keep-alive"(Text)

Date"Sat, 07 May 2022 05:15:21 GMT"(Text)

x-amzn-RequestId"a9a9d1e9-4862-4646-9462-77cc995fae4b"(Text)

X-DNS-Prefetch-Control"off"(Text)

X-XSS-Protection"1; mode=block"(Text)

Access-Control-Allow-Origin"*"(Text)

Strict-Transport-Security"max-age=15552000; includeSubDomains"(Text)

x-amzn-Remapped-Content-Length"1882"(Text)

X-Frame-Options"DENY"(Text)

Access-Control-Allow-Headers"Content-Type, Authorization"(Text)

x-amzn-Remapped-Connection"keep-alive"(Text)

X-Download-Options"noopen"(Text)

x-amz-apigw-id"RvUAdFUjBcwFV-g="(Text)

X-Content-Type-Options"nosniff"(Text)

ETag"W/"75a-vZldKSr+Uzs3ibF6y0eG3spQGDQ""(Text)

Access-Control-Allow-Methods"GET,POST,OPTIONS"(Text)

Access-Control-Expose-Headers"Version"(Text)

X-Amzn-Trace-Id"Root=1-62760069-6ea36468466e0a1301b30805"(Text)

x-amzn-Remapped-Date"Sat, 07 May 2022 05:15:21 GMT"(Text)

Access-Control-Allow-Credentials"true"(Text)

Vary"Accept-Encoding"(Text)

X-Cache"Miss from cloudfront"(Text)

Via"1.1 64969ea0eb4e790e92a77dba357e9b06.cloudfront.net (CloudFront)"(Text)

X-Amz-Cf-Pop"BOM78-P2"(Text)

X-Amz-Cf-Id"v4Yuxm5ju_21Nozd47cO-AieUtQnRO01F4N8kxUpAN_02QA_rzUzcQ=="(Text)

contentType"application/json; charset=utf-8"(Text)

bodyDictionary

sessionsList of Dictionary - 3 items

Dictionary

center_id595894(Number (Integer))

name"Padana PHC"(Text)

address"PHC Padana"(Text)

state_name"Gujarat"(Text)

district_name"Jamnagar"(Text)

block_name"Lalpur"(Text)

pincode361280(Number (Integer))

from"09:00:00"(Text)

to"18:00:00"(Text)

lat22(Number (Integer))

long69(Number (Integer))

fee_type"Free"(Text)

session_id"1b5b7184-1a29-414c-91a7-b46222fe1954"(Text)

date"07-05-2022"(Text)

available_capacity10(Number (Integer))

available_capacity_dose10(Number (Integer))

available_capacity_dose20(Number (Integer))

fee"0"(Text)

allow_all_agetrue(Boolean)

min_age_limit15(Number (Integer))

vaccine"COVAXIN"(Text)

slotsList of Dictionary - 4 items

Dictionary

time"09:00AM-11:00AM"(Text)

seats0(Number (Integer))

Dictionary

time"11:00AM-01:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"01:00PM-03:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"03:00PM-06:00PM"(Text)

seats0(Number (Integer))

Dictionary

center_id595894(Number (Integer))

name"Padana PHC"(Text)

address"PHC Padana"(Text)

state_name"Gujarat"(Text)

district_name"Jamnagar"(Text)

block_name"Lalpur"(Text)

pincode361280(Number (Integer))

from"09:00:00"(Text)

to"18:00:00"(Text)

lat22(Number (Integer))

long69(Number (Integer))

fee_type"Free"(Text)

session_id"022a14f7-5eab-4da0-8a01-cc56ea83cca4"(Text)

date"07-05-2022"(Text)

available_capacity10(Number (Integer))

available_capacity_dose10(Number (Integer))

available_capacity_dose20(Number (Integer))

fee"0"(Text)

allow_all_agefalse(Boolean)

min_age_limit18(Number (Integer))

max_age_limit44(Number (Integer))

vaccine"COVISHIELD"(Text)

slotsList of Dictionary - 4 items

Dictionary

time"09:00AM-11:00AM"(Text)

seats0(Number (Integer))

Dictionary

time"11:00AM-01:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"01:00PM-03:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"03:00PM-06:00PM"(Text)

seats0(Number (Integer))

Dictionary

center_id579663(Number (Integer))

name"Dabasang CHC"(Text)

address"Dabasang CHC"(Text)

state_name"Gujarat"(Text)

district_name"Jamnagar"(Text)

block_name"Lalpur"(Text)

pincode361280(Number (Integer))

from"09:00:00"(Text)

to"18:00:00"(Text)

lat22(Number (Integer))

long69(Number (Integer))

fee_type"Free"(Text)

session_id"624a4ba8-dee4-42bc-82b6-94b9d762348c"(Text)

date"07-05-2022"(Text)

available_capacity90(Number (Integer))

available_capacity_dose10(Number (Integer))

available_capacity_dose20(Number (Integer))

fee"0"(Text)

allow_all_agefalse(Boolean)

min_age_limit18(Number (Integer))

max_age_limit44(Number (Integer))

vaccine"COVISHIELD"(Text)

slotsList of Dictionary - 4 items

Dictionary

time"09:00AM-11:00AM"(Text)

seats0(Number (Integer))

Dictionary

time"11:00AM-01:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"01:00PM-03:00PM"(Text)

seats0(Number (Integer))

Dictionary

time"03:00PM-06:00PM"(Text)

seats0(Number (Integer))

errornull(Null)

connectedSystemnull(Connected System)

binaryDoc75MbLimitExceededfalse(Boolean)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
+1 GopalK
Certified Lead Developer
over 2 years ago in reply to jignesht0001
Hi, Try configuring your grid like below configuration.

a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: local!result.result.body.sessions, columns: { a!gridColumn( label: "Center Name", value: fv!row.name )
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 jignesht0001
Certified Senior Developer
over 2 years ago in reply to GopalK

Thank you so much its working fine now. Can you please explain me these. When value was fv!row.seesions.name it was showing in one row only and when selected value as fv!row.name it shows in different rows can you please explain me these.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 GopalK
Certified Lead Developer
over 2 years ago in reply to jignesht0001

Hi jignesht0001, You were not indexing correctly from the result which you got from integration. You need to understand how grid works and data iterates through rows. I assume you are new to Appian. Its good you are getting familiar with integrations and Web Api but i would also suggest you to go through Appian docs & tutorials to understand basic concepts of it. At least familiarize yourself with common objects, functions, recipes , data manipulations, CDT structure. not only it will clear your basic concepts but also it will strengthen your hold in Appian.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jignesht0001
Certified Senior Developer
over 2 years ago in reply to GopalK

Yes , I am new into appian. I have just started learning Appian. Thank you so much for giving me this valuable advice and supporting me I will first go through the documents and tutorials to understand and make my base stronger. Thank you so much once again
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel