API url

[dutta.marina (rpa_06)]

Hi All,

I am doing a http GET request using below url where aIp8Y000000GpIhSAK may vary everytime . I have captured that in variable quote_num , how the final url will be with variable

“https://databricks--uat2.sandbox.my.salesforce.com/services/data/v54.0/query/?q=select+ContentDocument.LatestPublishedVersionId+from+ContentDocumentLink+WHERE+LinkedEntityId+=+‘aIp8Y000000GpIhSAK’+ORDER+BY+ContentDocument.LastModifiedDate+DESC+LIMIT+1”

@Anil_G any help on this?

[Parvathy (PS Parvathy)]

Hi @dutta.marina

Try this:

quote_num = "aIp8Y000000GpIhSAK"

apiUrl = "https://databricks--uat2.sandbox.my.salesforce.com/services/data/v54.0/query/?q=select+ContentDocument.LatestPublishedVersionId+from+ContentDocumentLink+WHERE+LinkedEntityId+=+'" + quote_num + "'+ORDER+BY+ContentDocument.LastModifiedDate+DESC+LIMIT+1"

Hope it helps!!

[pravallikapaluri]

Hi @dutta.marina

Assign urlTemplate = "https://databricks--uat2.sandbox.my.salesforce.com/services/data/v54.0/query/?q=select+ContentDocument.LatestPublishedVersionId+from+ContentDocumentLink+WHERE+LinkedEntityId+=+'{0}'+ORDER+BY+ContentDocument.LastModifiedDate+DESC+LIMIT+1"

Assign quote_num = "aIp8Y000000GpIhSAK"

[dutta.marina (rpa_06)]

@Parvathy

I am getting error below

[dutta.marina (rpa_06)]

@pravallikapaluri

what you have taken final url ?

[pravallikapaluri]

@dutta.marina

Sorry,Check the below one

finalUrl="https://databricks--uat2.sandbox.my.salesforce.com/services/data/v54.0/query/?q=select+ContentDocument.LatestPublishedVersionId+from+ContentDocumentLink+WHERE+LinkedEntityId+=+'" + quote_num + "'+ORDER+BY+ContentDocument.LastModifiedDate+DESC+LIMIT+1"

[Parvathy (PS Parvathy)]

Hi @dutta.marina

Can you share the JSON file that you are using?

Regards

[dutta.marina (rpa_06)]

@Parvathy

I am trying to re[licate this from postman and want to get latestpublished version Id from quoteid whicg is aIp8Y000000GpIhSAK’

[dutta.marina (rpa_06)]

@Parvathy

I am getting invalid session id. I am increased the Time Out also to 60000

[Parvathy (PS Parvathy)]

Hi @dutta.marina

Can you try using Deserialize JSON Array activity.

Regards

[Anil_G (Anil Gorthi)]

@dutta.marina

Can you please show the json string you are trying to deserialize?

Cheers