Need little help with on Edit Rows Api given by Glide

[Dilip_Adiga]

Hi Guys,

I have Edit Rows curl given by glide

curl --request POST ‘https://api.glideapp.io/api/function/mutateTables’
–header ‘Content-Type: application/json’
–header 'Authorization: Bearer ’
–data-raw ‘{
“appID”: “”,
“mutations”: [
{
“kind”: “set-columns-in-row”,
“tableName”: “native-table-”,
“columnValues”: {
“Name”: “CreatorName”,
“5VUOe”: “IGHandle”,
“Em3JW”: “StillwithUse”,
“PyW93”: “InboundSafe”,
“kQZeJ”: “100% Compliant”,
“S5oUM”: “FetchData”,
“GGvzu”: “Followers”,
“nkA9b”: “Location”,
“11mZI”: “Rating”,
“jnRla”: “Category”,
“DoAcI”: “Owner”,
“Hk6we”: “EmailBio”,
“RZaLc”: “Reason”,
“2KAvd”: “Inbounds ( Either to Talent Personal )”,
“47uiz”: “Contract expiry”,
“uoBRL”: “Address”,
“G3aLq”: “BankAccname”,
“Ris4t”: “IFSC”,
“ltUQ2”: “BankAccnumber”,
“zori5”: “StillwithUsData”,
“NMGQi”: “InboundSafeData”,
“9G6sb”: “100%CompliantData”,
“AgT4Z”: “Inbound%Data”,
“89zzo”: “Inbound%Data”,
“WaJml”: “100%CompliantData%”,
“kTWXf”: “LinkProfile”,
“R6zit”: “InboundSafeEntrydate”,
“e9RjW”: “InboundSafeRemovedDate”,
“9lBHT”: “EngagementRate”,
“8Hvgg”: “AvgReelViews”
},
“rowID”: “ROW-ID”
}
]
}’

Question 1: Can I give it to someone and asked them to use this API to write some values into my table?

Also has anyone used this API? What would be a sample response / request ?

They will search my row_ID and write values to some columns.

Regards,
Dilip

[Eric_Penn]

@Dilip_Adiga

Can I give it to someone and asked them to use this API to write some values into my table?

Yes. You should trust them because they will need your key.

@Dilip_Adiga

Also has anyone used this API? What would be a sample response / request ?

If you can use Make. The native Glide modules are very easy to use.

@Dilip_Adiga

“ltUQ2”: “BankAccnumber”,

FYI you’re not supposed to store bank account numbers in Glide.

[Dilip_Adiga]

Thank you for responding @Eric_Penn

@Eric_Penn

FYI you’re not supposed to store bank account numbers in Glide.

Sure thing , this is just me testing few things around.

@Eric_Penn

If you can use Make. The native Glide modules are very easy to use.

not sure why would I need Make? I can pass them the API and they would be able to write directly into my table right?

Regards,
Dilip

[Eric_Penn]

Make is one of our goto tools for automation and interacting with API’s. Of course it’s not mandatory.

Personally, I don’t give out access to my API.

[Dilip_Adiga]

Got It Eric,

thank you for helping me out.

Regards,
Dilip

[ThinhDinh]

Why don’t you just ask them to upload data to your app instead of using the API? Or giving you the file to upload in the data view?

[Dilip_Adiga]

Hi @ThinhDinh ,

Thank you for replying.

@ThinhDinh

Why don’t you just ask them to upload data to your app instead of using the API?

Oh by third party I mean these are data service providers who get list of all people and give me corresponding data which keeps changing on monthly basis

Few data needs to be updated daily. So Asking them to upload specially when there are lot of data would not be feasible use case. As this is not individual users who are putting up data.

@ThinhDinh

giving you the file to upload in the data view?

Wanted to completely remove a dependency in flow so was thinking of using api approach where they get data and they write to my table.

Also @ThinhDinh wanted to know wether data can be input as form data for this api?

I tried using the api curl in postman with form data it gave me error saying

“Unsupported Media Type”

In form data I was inputting rowID and corresponding one field as text and giving a value

GGvzu is referring to columnn in my DB which is of type Number

Not sure wether I am doing it right

EX

Could you let me know if I am doing something wrong?

Regards,
Dilip

[Darren_Murphy]

You are using form-data. You should choose raw->JSON

[Dilip_Adiga]

Thank you. It worked.

Regards,
Dilip