Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Getting Error with POST to currency field

Topic Labels: API Scripting
Solved
Jump to Solution
1924 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

I am working in Postman. The field in question is "Taxes Owed - PDF". I get the error shown below. If I change the field type to single-line text I don't get an error. I don't want to change the field type. How do I avoid the error?  I have also tried other values: $3333, $3333.00, 3300.00, $3,333.00

TIA

{
    "error": {
        "type": "INVALID_VALUE_FOR_COLUMN",
        "message": "Field \"Taxes Owed - PDF\" cannot accept the provided value"
    }
}

 

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": "3333"
    }
}
2 Solutions

Accepted Solutions
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

I was able to figure it out. Quotes should not be used for currency.

This worked:

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": 3333
    }
}

 

See Solution in Thread

ScottWorld
18 - Pluto
18 - Pluto

Ha, yes. You probably didn’t see that I posted the answer a few minutes before you figured it out. 😝

See Solution in Thread

5 Replies 5

Do not put quotation marks around the number.

Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

I was able to figure it out. Quotes should not be used for currency.

This worked:

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": 3333
    }
}

 

ScottWorld
18 - Pluto
18 - Pluto

Ha, yes. You probably didn’t see that I posted the answer a few minutes before you figured it out. 😝

posting. I marked your answer as asolution too.Yes- Thanks for

ScottWorld
18 - Pluto
18 - Pluto

You’re welcome! I’m glad you figured it out on your own, too! Great job!! 😎🙌